Excel Excel and Percentrank Criteria Issue

P

petert

Joined
Nov 26, 2008
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How To Percentrank by Specific Range 1
Excel How to find the most common pairs and triplets numbers? 5
Add Values that Match 2 Criteria Q 1
Redistribution of values after reaching maximum 4
How do I sum here using criteria there? 10
Sumif multiple criteria? 3
Automatically condense a field of data to eliminate blank lines 2
Sum total using Sumproduct if two criteria met 5

Top