Forum Discussion
finding a result when all the cells are not equal
I have a sheet that has data validation with 4 possible entries: Merchant, Distributor, Partner, and Reseller These 4 possibilities are used in 6 different rows. I need to identify a value based on if...
Hello Marlise
Simply count how often the first value appears in the six rows.
=COUNTIF(A1:A6,A1)=6