| A |B| C |
--|-----|-|-----|--
1 | 100 | | 900 |
2 | 300 | | 700 |
3 | 900 | | 600 |
4 | 500 | | 500 |
5 | 400 | | 400 |
6 | 200 | | |
7 | 700 | | |
8 | 800 | | |
9 | 600 | | |
10| 120 | | |
In Cell C1
I want to sort Column A
in a descending order and only show the Top5 results.
So far I have been able to develop this formula:
=SORT(A1:A10,,-1)
However, it displays the entire results. How do I need to modify it to only show the Top5?