Forum Discussion

darronsmom's avatar
darronsmom
Copper Contributor
Sep 07, 2018

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_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hello Marlise

     

    Simply count how often the first value appears in the six rows.

    =COUNTIF(A1:A6,A1)=6

     

Resources