functions largest to smallest
 

I am looking for a function that will arrange a group of cells from largest
to smallest. This formula has to be within my worksheet. I need to show 1st
place, 2nd place, 3rd place, etc. After the program calculates the scores it
then needs to show who won these places and the name of winners.

Can someone help me with this?

functions largest to smallest
 

On the assumption all the scores are in a single column on the worksheet why
don't you simply sort the data by that column.

"Sevengails" wrote:

I am looking for a function that will arrange a group of cells from largest
to smallest. This formula has to be within my worksheet. I need to show 1st
place, 2nd place, 3rd place, etc. After the program calculates the scores it
then needs to show who won these places and the name of winners.

Can someone help me with this?

functions largest to smallest
 

If this is not what you want, look at Rank in help.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Mike" wrote in message
...
On the assumption all the scores are in a single column on the worksheet
why
don't you simply sort the data by that column.

"Sevengails" wrote:

I am looking for a function that will arrange a group of cells from
largest
to smallest. This formula has to be within my worksheet. I need to show
1st
place, 2nd place, 3rd place, etc. After the program calculates the
scores it
then needs to show who won these places and the name of winners.

Can someone help me with this?