Forum Discussion

kneel1026's avatar
kneel1026
Copper Contributor
Jul 14, 2022
Solved

Need help with an Excel formula

I'm not a very advanced Excel user but need to create a function in the first column of the following table, in which the formula returns the word 'multiple' if the "AttributeID" column has the same ...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jul 14, 2022

    kneel1026 

    =IF(COUNTIF($H$2:$H$11,H2)=1,"single","multiple")

    You can try this formula.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jul 14, 2022

kneel1026 

=IF(COUNTIF($H$2:$H$11,H2)=1,"single","multiple")

You can try this formula.

 

  • kneel1026's avatar
    kneel1026
    Copper Contributor
    Jul 14, 2022
    Thank you @QuadruplePawn - that worked. Appreciate your help!

Resources