Hello Everyone
I’ve been trying to figure this out with no success
I have a report with several regions and each region has several markets
Regions are in Column A
Markets in Column B
Performance Results are in column AB
I’m trying to I identify the regions with the most number of markets in the top 10 based on their results
Example if the “South East” Region has 3 markets in the Top 10
The result I like in a range on another sheet, sheet 1, $A$1:$C$10, Column A the Region, Column B the Market and Column the performance
How can I achieve this?
Thanks
I’ve been trying to figure this out with no success
I have a report with several regions and each region has several markets
Regions are in Column A
Markets in Column B
Performance Results are in column AB
I’m trying to I identify the regions with the most number of markets in the top 10 based on their results
Example if the “South East” Region has 3 markets in the Top 10
The result I like in a range on another sheet, sheet 1, $A$1:$C$10, Column A the Region, Column B the Market and Column the performance
How can I achieve this?
Thanks