Anglais428v2
New Member
- Joined
- Jun 19, 2020
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
I have a formula that does exactly what I want - it gives me the top ten sectors (names) ordered highest to lowest. The formula is:
=LET(u,UNIQUE(FILTER(Sector,year>MIN(year))),TAKE(SORTBY(u,COUNTIFS(Sector,u),-1),10))
I now want to reorder the above list (of 10 sectors highest-lowest) to lowest to highest. The purpose of this is so the chart looks better
So the ideal new result would be to switch the above table from A-I order to I-A.
=LET(u,UNIQUE(FILTER(Sector,year>MIN(year))),TAKE(SORTBY(u,COUNTIFS(Sector,u),-1),10))
I now want to reorder the above list (of 10 sectors highest-lowest) to lowest to highest. The purpose of this is so the chart looks better
Sector | Count |
A | 100 |
B | 75 |
C | 59 |
D | 56 |
E | 49 |
F | 37 |
G | 36 |
H | 35 |
I | 23 |
J | 17 |
So the ideal new result would be to switch the above table from A-I order to I-A.