I have a spreadsheet which contains 1400 events or groups,listed in
column1Each memeber of each group has a rating shown in column2. I have
filled in manually to column 3 what I need.i.e how much each member of
the group is below the top memeber of the group.
There are over 40 columns in the full sheet and I dont want to go
sorting,or disturb anything, I need a formula to autofill in col3 see
attached.
+-------------------------------------------------------------------+
|Filename: attempt1.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=5215 |
+-------------------------------------------------------------------+
--
pytelium
------------------------------------------------------------------------
pytelium's Profile:
http://www.excelforum.com/member.php...o&userid=25521
View this thread:
http://www.excelforum.com/showthread...hreadid=572557