Forum Discussion
darronsmom
Sep 07, 2018Copper Contributor
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 all 6 rows have the same value, or are not equal. For example, if the values look like the below, I would expect the result to be "Eligible" Merchant Merchant Merchant Merchant Merchant Merchant If the six lines are not equal, I would expect the result to be "Not Eligible". Merchant Reseller Distributor Merchant Merchant Reseller I was thinking about Index/Match, but since I have to compare the value in all 6 rows to see if all 6 are the same or different, I wasn't sure if that was the best way to handle this? Thanks in advance
- Detlef_LewinSilver Contributor
Hello Marlise
Simply count how often the first value appears in the six rows.
=COUNTIF(A1:A6,A1)=6