Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How To Percentrank by Specific Range
0 views
Skip to first unread message
petertremain
Nov 26, 2008, 3:53:37 AM11/26/08
to
Hi, Not sure if i am in the right spot but i am in a real bind and hoping someone can assist.
I have a sheet containing 2 Columns of Data Column A Job Title and C is Salary.
A B
Elec $8
Plumber $12
Tech $10
Elec $76
Plumber $22
Tech $56
I can easily percentrank the total of all salaries by using the following
=percentrank(B1:B150,B1) however;
I need to percentrank the titles rather than the total of all such as percentrank of all "Tech's".
I have tried If and Sumproduct but neither provide the result.
Any help appreciated.
Many thanks
Peter
JP
Nov 26, 2008, 8:08:39 AM11/26/08
to
Percentrank works on values. What exactly are you trying to do? Maybe
if you explain your goal, someone can suggest another function that
might be more suitable.
if you explain your goal, someone can suggest another function that
might be more suitable.
--JP
0 new messages