Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Percentrank by Specific Range
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel PERCENTRANK help | Excel Worksheet Functions | |||
Percentrank Function | Excel Worksheet Functions | |||
Count Specific word in specific range | Excel Worksheet Functions | |||
Count If Specific word in specific range | Excel Discussion (Misc queries) | |||
Percentage/PERCENTRANK | Excel Worksheet Functions |