Need help with an Excel formula

[kneel1026]

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 number in multiple rows, or returns the word 'single' if it does not.  Is it better to use a CountIf formula or a Lookup formula? and how do I define the criteria in which to return the 'multiple or single result?

Single or Multiple?	Type	MetricId	MetricName	Display Name	ParentId	AttributetypeId	AttributeId	AttributeTypeLevel1	AttributeTypeLevel2	SpssVariable	Loop	SpssValue
	Custom Brand	9645	Corolla	Corolla	9241	177	391286	Custom Brand	Corolla	Q1_2f	0	2068
	Custom Brand	9646	Camry	Camry	9241	177	391287	Custom Brand	Camry	Q1_2f	0	20698
	Custom Brand	9647	Camry	Camry	9241	177	391287	Custom Brand	Camry	Q1_2f	0	20699
	Custom Brand	14887	Crosstrek	Crosstrek	4653	177	391291	Custom Brand	Crosstrek	Q1_3a	0	3011
	Custom Brand	14888	Outback	Outback	4653	177	391294	Custom Brand	Outback	Q1_3a	0	3012
	Custom Brand	14891	Outback	Outback	4653	177	391294	Custom Brand	Outback	Q1_3a	0	3014
	Custom Brand	14893	Outback	Outback	4653	177	391294	Custom Brand	Outback	Q1_3a	0	3016
	Custom Brand	14894	Fusion	Fusion	5291	177	391299	Custom Brand	Fusion	Q1_3a	0	3017
	Custom Brand	14895	Suburban	Suburban	6100	177	391300	Custom Brand	Suburban	Q1_3a	0	3018
	Custom Brand	14896	Enclave	Enclave	3256	177	391301	Custom Brand	Enclave	Q1_3a	0	3019

[#2 · Accepted solution]

@kneel1026 

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

You can try this formula.

 

[#3]

Thank you @QuadruplePawn - that worked. Appreciate your help!