Tally Position of Data

  • Thread starter Thread starter Laddy
  • Start date Start date
L

Laddy

Hello,
Sorry for the strange way I have labelled the 'subject' but that is all I
could think of.

I wish to return the position of a person in a list. That person's position
will change daily by the introduction of points gained.

There are 3 columns:
Column 1 has the persons name
Column 2 has the points gained
Column 3 is the current position

The table is below
Col A Col B Col C
Name Points Position
Tom 40
Dick 50
Harry 25


What is the formula to produce
Name Points Position
Tom 40 2
Dick 50 1
Harry 25 3


Thanks if you can help

Laddy
 
Laddy said:
Hello,
Sorry for the strange way I have labelled the 'subject' but that is all I
could think of.

I wish to return the position of a person in a list. That person's position
will change daily by the introduction of points gained.

There are 3 columns:
Column 1 has the persons name
Column 2 has the points gained
Column 3 is the current position

The table is below
Col A Col B Col C
Name Points Position
Tom 40
Dick 50
Harry 25


What is the formula to produce
Name Points Position
Tom 40 2
Dick 50 1
Harry 25 3


Thanks if you can help

Laddy
Click to expand...
 
Thank you very much Chip. In the help file I did not try the correct input
so did not come up with 'Rank'
 
Back
Top