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

Hi,

Please clarify your question.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Skip" wrote in message
...
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

After ranking them, copy column F and the EditPasteSpecialValues and then
sort by column F.

--
__________________________________
HTH

Bob

"Skip" wrote in message
...
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

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 DataSort
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



"Skip" wrote in message
...
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

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.


"MartinW" wrote:

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 DataSort
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



"Skip" wrote in message
...
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