ARE ALL THE CELLS EQUAL?

  • Thread starter Thread starter Faraz A. Qureshi
  • Start date Start date
F

Faraz A. Qureshi

Instead of entering a lengthy formula like:

=IF(OR(D12<>D7,D7<>E9,E9<>G2,G2<>H17,H17<>F11,F11<>I6),"OUT","OK")

Any idea how to determine if all the cells are equal by entering address of
each cell once only, namely:
D12, D7, E9, G2, H17, F11, I6
or that of a range, like:
B1:B50
only once?

Thanx in advance.
 
If A1 is not blank..the below will do

=IF(COUNTIF(A1:A10,A1)=ROWS(A1:A10),"All cells are same","Not same")

If this post helps click Yes
 
Here's another approach...

Array entered** :

=IF(AND(A1:A10=A1),"Same","Not the Same")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
 
Isn't there anyway for cells not in an array but distributed?
--
Best Regards,

Faraz



T. Valko said:
Here's another approach...

Array entered** :

=IF(AND(A1:A10=A1),"Same","Not the Same")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
Click to expand...
 
=IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT")

How did you know the data was numeric?


--
Biff
Microsoft Excel MVP


David Biddulph said:
=IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT")
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking two IF statements together 2
Shortening or changing a formula 7
Data Entry Form: Complex Example 4
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Excel A CountIF question... I think 2
Payment calculation 1
Change cell colour 2
Looking uprange for next nonblank cell 4

Back
Top