whatever999
New Member
- Joined
- Mar 5, 2018
- Messages
- 2
Hi,
I have the following data:
<tbody>
</tbody>
I want to rank top 3 cities by customers (regardless of day). Desired result:
Top 1: WA , 3900
Top 2: CA, 3700
Top 3: NY, 1800
Top 4: OR, 200
How can I do that with one formula?
thanks
I have the following data:
Day | State | Customers | ||
1 | NY | 500 | ||
2 | NY | 300 | ||
3 | NY | 1000 | ||
1 | CA | 800 | ||
1 | WA | 900 | ||
1 | OR | 200 | ||
2 | CA | 400 | ||
2 | WA | 3000 | ||
3 | CA | 2500 |
<tbody>
</tbody>
I want to rank top 3 cities by customers (regardless of day). Desired result:
Top 1: WA , 3900
Top 2: CA, 3700
Top 3: NY, 1800
Top 4: OR, 200
How can I do that with one formula?
thanks