Check that all cells in a range have same values

  • Thread starter Thread starter Finny388
  • Start date Start date
F

Finny388

All the formulas I can find pertain to only checking one cell agains
another:
EXACT() - "Compares two text strings and returns TRUE if they are
exactly the same..."

Is there no formula to compare several strings? Seems silly.

2007 only has 5 new formulas? yikes.
 
Finny,

=IF(COUNTIF(A:A,A1)=COUNTA(A:A),"ALL are the same","NOT all are the same")

can be used to tell if all the entries in column A are all the same.

HTH,
Bernie
MS Excel MVP
 
Finny,

=IF(COUNTIF(A:A,A1)=COUNTA(A:A),"ALL are the same","NOT all are the same")

can be used to tell if all the entries in column A are all the same.

HTH,
Bernie
MS Excel MVP
Click to expand...

thanks! nice work!
 

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 appearing as Value in Formula Bar 1
Find duplicate range or cell ref (as precedents) in a cell's formula - an example 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Comparing a vba variable to a range of cells 5
A way to count cells in a range containing text or formulas 2
Hide value of cell if value same as other cell 1
Bold items within text string 7
Compare 2 excel sheets -Error Checking of entered names 1

Back
Top