Rank top 10 Projects from highest to lowest

[Anonymous]

Hi,

I have a lot of projects in which I would like to display only the top 10 based on their project value. So highest to lowest, and only the top 10. How do I do this? 

Out of these 26 projects I only need the top 10 based on the project value. Please help, thank you

Title                                                                           

Project 1

Project 2

Project 3

Project 4

Project 5

Project 6

Project 7

Project 8

Project 9

Project 10

Project 11

Project 12

Project 13

Project 14

Project 15

Project 16

Project 17

Project 18

Project 19

Project 20

Project 21

Project 22

Project 23

Project 24

Project 25

Project 26

Project Value

120K

8M

150M

500M-1B

67M

69M

8BN

4M

15M

200M

400M

5.8BN

7BN

2.3B

>1BN

500M

15M

1.5BN & 750M

1.2BN

55M

47M

1M

39M

130M

200M

>1BN

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

See pic above, left is original table, right is top 10 based on project value.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel