troubleshooting Question

Variate of Percentrank

Avatar of Seamus2626
Seamus2626Flag for Ireland asked on
Microsoft Excel
2 Comments1 Solution180 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros