Jul 14 2022 07:46 AM
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 |
Jul 14 2022 10:54 AM
SolutionJul 14 2022 11:29 AM
Jul 14 2022 10:54 AM
Solution=IF(COUNTIF($H$2:$H$11,H2)=1,"single","multiple")
You can try this formula.