Need help with an Excel formula

Question

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.&nbsp; 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?TypeMetricIdMetricNameDisplay NameParentIdAttributetypeIdAttributeIdAttributeTypeLevel1AttributeTypeLevel2SpssVariableLoopSpssValue&nbsp;Custom Brand9645CorollaCorolla9241177391286Custom BrandCorollaQ1_2f02068&nbsp;Custom Brand9646CamryCamry9241177391287Custom BrandCamryQ1_2f020698&nbsp;Custom Brand9647CamryCamry9241177391287Custom BrandCamryQ1_2f020699&nbsp;Custom Brand14887CrosstrekCrosstrek4653177391291Custom BrandCrosstrekQ1_3a03011&nbsp;Custom Brand14888OutbackOutback4653177391294Custom BrandOutbackQ1_3a03012&nbsp;Custom Brand14891OutbackOutback4653177391294Custom BrandOutbackQ1_3a03014&nbsp;Custom Brand14893OutbackOutback4653177391294Custom BrandOutbackQ1_3a03016&nbsp;Custom Brand14894FusionFusion5291177391299Custom BrandFusionQ1_3a03017&nbsp;Custom Brand14895SuburbanSuburban6100177391300Custom BrandSuburbanQ1_3a03018&nbsp;Custom Brand14896EnclaveEnclave3256177391301Custom BrandEnclaveQ1_3a03019

oliverscheurich · Accepted Answer

kneel1026&nbsp;=IF(COUNTIF($H$2:$H$11,H2)=1,"single","multiple")You can try this formula.&nbsp;

Forum Discussion

Need help with an Excel formula

2 Replies

Resources

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