Hi, can anyone help me show a formula in Excel? Let's say:
01258
74125
85644
74581
I have these numbers in one chart, and I want to use a formula in Excel to identify numbers outside of this set, the answer being 3 and 9.
1) Can anyone show me in Excel what formula I should use?
2) How do I use color to highlight in red?
01258
74125
85644
74581
The target number is 5. This number must be highlighted in the box as shown in the example.
What formula should I use?
Thanks in advance.
From Malaysia, Semenyih
Acknowledge(0)
Amend(0)
01258
74125
85644
74581
I have these numbers in one chart, and I want to use a formula in Excel to identify numbers outside of this set, the answer being 3 and 9.
1) Can anyone show me in Excel what formula I should use?
2) How do I use color to highlight in red?
01258
74125
85644
74581
The target number is 5. This number must be highlighted in the box as shown in the example.
What formula should I use?
Thanks in advance.
From Malaysia, Semenyih
Acknowledge(0)Amend(0)
Just check wheather this attached file is of any use to you
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi, can anyone help me with Excel? What formula should I use to identify numbers 3 and 9 from the chart below:
457812
852147
458561
147248
I want to target number 5 as shown in the example below:
Target number: 5
457812
852147
458561
147248
When the target number is entered, it should be highlighted in red on the chart. Can someone please teach me which formula to use for this? Thanks in advance for your help. I appreciate the valuable Excel format you provided, but I am still unable to find the correct formula. Could someone please help by attaching a sample Excel file? Thank you.
From Malaysia, Semenyih
Acknowledge(0)Amend(0)
457812
852147
458561
147248
I want to target number 5 as shown in the example below:
Target number: 5
457812
852147
458561
147248
When the target number is entered, it should be highlighted in red on the chart. Can someone please teach me which formula to use for this? Thanks in advance for your help. I appreciate the valuable Excel format you provided, but I am still unable to find the correct formula. Could someone please help by attaching a sample Excel file? Thank you.
From Malaysia, Semenyih
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
EXCEL FORMULA.xls