Hello!

I'm trying to find a way to see if all the values (usually text) in a list are the same.

One way I can do this is to do

=COUNTIF(B11:B25,B11)=COUNTA(B11:B25)
This counts how many instances there are of the value in B11, and then compares this to how many overall values there are in the range & returns true/false

This does work, but when I filter on a field, it still takes into account the excluded rows. I almost needs to be like a subtotal, but whilst there is a subtotal for COUNTA, there isn't for COUNTIF, so the COUNTIF will still count the hidden rows.

The other problem with this method, is that the first row wont always be B11, depending on how it's been filtered.

Any ideas on how to do this other than VBA?

Many thanks!