Hi, can anyone help me in Excel? What formula should I use if:
457812
852147
458561
147248
I want to identify the numbers outside the chart. The answer is 3 and 9.
1) Which formula should I use? Please teach me.
2) From this chart, I want to target the number as shown below.
Target number: 5
457812
852147
458561
147248
When the target number is input, it should be highlighted in red on the chart.
3) Or should the cell be highlighted in red on the chart? Please teach me. Thank you in advance.
From Malaysia, Semenyih
Acknowledge(0)
Amend(0)
457812
852147
458561
147248
I want to identify the numbers outside the chart. The answer is 3 and 9.
1) Which formula should I use? Please teach me.
2) From this chart, I want to target the number as shown below.
Target number: 5
457812
852147
458561
147248
When the target number is input, it should be highlighted in red on the chart.
3) Or should the cell be highlighted in red on the chart? Please teach me. Thank you in advance.
[IMG]https://www.citehr.com/images/misc/progress.gif[/IMG]
From Malaysia, Semenyih
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
EXCEL FORMULA.xls