MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Array formula, I think??


Posted by Heidi on February 05, 2002 3:25 PM

Hello,
I am trying to complete a formula that will look at a list of values (say e5:e200) and then return the percentage of those values that are greater than a value in a specified cell (say the value contained in cell E4). Does anyone know the simplest way to accomplish this? Any help would be greatly appreciated

Sincerely,

Heidi

Clippy doesn't have all the answers..


Posted by Aladin Akyurek on February 05, 2002 3:40 PM

An ordinary, simple formula will do:

=COUNTIF(e5:e200,">"&E4)/COUNT(e5:e200)

=========

Posted by Heidi on February 05, 2002 3:44 PM

Thank you:)


Posted by Scott R on February 11, 2002 4:33 PM

=1-PERCENTRANK(E5:E200,E4)