Using the RANK function question.

[Skip]

In column A I have a list of 20 salespeople names.
After a series of calculations I have a, for lack of a better
name a performance number in column F. I know I can rank column F,
Is there any way I can rank the names(column A) using the number in
column F? Thanks in advance for any help.
Skip

 

[Ashish Mathur]

Hi,

Please clarify your question.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Bob Phillips]

After ranking them, copy column F and the Edit>PasteSpecial>Values and then
sort by column F.

 

[MartinW]

Hi Skip,

There is quite a few ways to do that sort of thing and which one you use
depends on what you have and what you want from it.

One take is to select A1:F20
Go to Data>Sort
Select column F from the dropdown
Check ascending and OK out.

If that or your other reply doesn't do it then post back with more detail
on what you have and what you are trying to achieve.

HTH
Martin

 

[LiAD]

Skip,

Dont really know either what exactly you want.

If you want to make it automatic you can rank the first column (or any
column you want actually), and then use index and match to fill out the rest
of the columns.