CODEWITHSUNDEEP
excelexcel-formulaworksheet-functioncountif
chris bahr
chris bahr

Reputation: 165

IF statement to show if ALL cells in a row have the same value

I want to write a formula in Excel to determine if EVERY cell in a row has the same value. There are five cells, for example: C2:G2 that I need to filter out only the ones with the same value, so if only one out of the five cells has it then it's fine, but if every single cell has the same value I need to take it out. So far the only formula I have been able to write just puts TRUE if the value is in any cell.

Upvotes: 1

Views: 8495

Answers (1)

pnuts
pnuts

Reputation: 59485

Please try:

=COUNTIF(C2:G2,C2)=5

Upvotes: 3

Related Questions