Position by week

  • Thread starter Thread starter BillyBoy
  • Start date Start date
B

BillyBoy

I have a spreadsheet with 16 weeks of data.
The 'weeks' are the columns
The 'Staff' are the rows

I have the problem of sorting the staffs position on a weekly. As the
position changes on a weekly basis i.e
(weeks) 1 2 3 4 .............

Fred 2 1 6 6
Mary 3 5 2 4
John 4 2 3 4
Susan 4 3 7 1

In week 1 John and Susan are first (1) Mary is third (2) and Fred is
Fourth(3)
Repeated over the sixteen weeks .

I want to keep the orginal data.

This is what I want.
(weeks) 1 2 3 4 .............

Fred 3 4 2 1
Mary 2 1 4 2
John 1 3 3 2
Susan 1 2 1 4


Thanks
 
Billy,

Look at the function Rank()

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Sorry,
Thats not completely what you need, since if there are more (lets say 3)
"numbers 2" it continues with 5 rather than with (what you want) 3.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Sorry,
Thats not completely what you need, since if there are more (lets say 3)
"numbers 2" it continues with 5 rather than with (what you want) 3.
Click to expand...

Thanks for your input that is what I needed. I was my error in the
inital post. I said :

This is what I want.
(weeks) 1 2 3 4 .............

Fred 3 4 2 1
Mary 2 1 4 2
John 1 3 3 2
Susan 1 2 1 4

But meant :
This is what I want.
(weeks) 1 2 3 4 .............

Fred 3 4 2 1
Mary 2 1 4 2
John 1 3 3 2
Susan 1 2 1 3
 
Back
Top