I found this wonderful formula last week in your forum that resolved an issue I was having that provided the top 3 most repeated values in a column.
= LET(
distinct, UNIQUE(zones),
count, COUNTIFS(zones, distinct),
ordered, SORTBY(distinct, count,-1),
INDEX(ordered, {1;2;3}))
Now, there is an extra hitch, I need to be able to find the top 3 most repeated values for each Model type identified in another column. Does anyone have a way that I can resolve this? Thank you.
= LET(
distinct, UNIQUE(zones),
count, COUNTIFS(zones, distinct),
ordered, SORTBY(distinct, count,-1),
INDEX(ordered, {1;2;3}))
Now, there is an extra hitch, I need to be able to find the top 3 most repeated values for each Model type identified in another column. Does anyone have a way that I can resolve this? Thank you.
Model Type | Zone |
---|---|
101 | 949 |
123 | 949 |
123 | 930 |
101 | 822 |
101 | 822 |
123 | 930 |
123 | 949 |