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
Seamus2626Asked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
Are you expecting 6 as the return value, and are you only looking for exact matches? If not, assuming your list is sorted descending:

=MATCH(A1,B1:B7,-1)

where A1 is the lookup value and B1:B7 is your value list. (If you want exact matches only, change the -1 to 0)
0
 
Seamus2626Author Commented:
Excellent again :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.