User Profile
kneel1026
Copper Contributor
Joined Jul 14, 2022
User Widgets
Recent Discussions
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 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 3019Solved1.2KViews0likes2Comments
Recent Blog Articles
No content to show