Statistics
See where a number ranks as a percent
=PERCENTRANK.INC(B2:B6,B3)How it works in Excel
- B2:B6 is the whole list.
- B3 is the number you are placing.
- Format the cell as a percentage.
The idea in general
It tells you what share of the group sits below this value.
What I assumed
- Your numbers are in B2:B6.
Check the result on your own data before relying on it.