ARE ALL THE CELLS EQUAL?

  • Thread starter Faraz A. Qureshi
  • 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.
 
J

Jacob Skaria

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
 
T

T. Valko

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.
 
F

Faraz A. Qureshi

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...
 
T

T. Valko

=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

Formula autofill to cells below – formula arguments are cell areas in different columns 1
Data Entry Form: Complex Example 4
using values entered in cells to determine a result in another cel 5
Shortening or changing a formula 7
Searching cells 2
Comparing 2 cells using vlookup 4
Request Form - Alert Team Member 0
Looking uprange for next nonblank cell 4

Top