Avatar of Seamus2626
Seamus2626
Flag for Ireland asked on

Variate of Percentrank

Hi,

With the function Percentrank i can get the % position of a number within a list
e.g


$5,000,193,672
$3,453,128,376
$2,233,115,680
$1,115,362,635
$487,910,974
$429,423,144
$370,761,798


$429,423,144 returns 16%

This is fine when you have the numbers in front of you, is there a way a user could type in $410,376,876 and then get the relative position of that number.

Many thanks
Seamus
Microsoft Excel

Avatar of undefined
Last Comment
Seamus2626

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rory Archibald

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Seamus2626

ASKER
Excellent again :-)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck