Finding Rank Within a segment
Hello-
I have a data set that looks like this. It's a list of products, a specific product segment or classification, and 2 sales metrics with last years values as well. I want to add columns at the end to find each products rank within each metric. I have a long list of products and about 12 different product segments, so I can't just use an =rank formula. How do I add a layer to my formula to search rank within the segment? For example in my 7th column (metric 1 rank), what is Item A rank within segment XYZ? Then What is Item B rank within segment ABC? No items show up in more than one segment and no items are repeated. Thanks!
Posted Jan 15, 2024, 3:55 PM UTC
12