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...
 
Back
Top