Scotster
Board Regular
- Joined
- May 29, 2017
- Messages
- 55
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi there,
I cannot for the life of me figure out how to go about extracting a top 10 table from a varying dataset. Any help would be appreciated.
Say I have the following:
Vendor TRT
Vendor1 10
Vendor2 12
Vendor6 36
Vendor3 13
Vendor1 42
Vendor4 15
Vendor6 18
Vendor4 23
Vendor2 32
Vendor3 30
Vendor1 18
Vendor2 7
Vendor3 7
Vendor4 18
Vendor5 12
Vendor6 30
Vendor7 41
Vendor8 19
Vendor9 50
Vendor10 75
How do I get the top 5 unique vendors based on TRT?
Many thanks
I cannot for the life of me figure out how to go about extracting a top 10 table from a varying dataset. Any help would be appreciated.
Say I have the following:
Vendor TRT
Vendor1 10
Vendor2 12
Vendor6 36
Vendor3 13
Vendor1 42
Vendor4 15
Vendor6 18
Vendor4 23
Vendor2 32
Vendor3 30
Vendor1 18
Vendor2 7
Vendor3 7
Vendor4 18
Vendor5 12
Vendor6 30
Vendor7 41
Vendor8 19
Vendor9 50
Vendor10 75
How do I get the top 5 unique vendors based on TRT?
Many thanks