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

=MAX($A$1:$A$1400)-A1
Fill down to C1400

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

This is only subtracts the value from the overall maximum and not the
maximum within each event or group--see attached and compare with
attempt 1.


+-------------------------------------------------------------------+
|Filename: attempt2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5216 |
+-------------------------------------------------------------------+

--
pytelium
------------------------------------------------------------------------
pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521
View this thread: http://www.excelforum.com/showthread...hreadid=572557

Still no solution,tried using th LARGE function without success!


--
pytelium
------------------------------------------------------------------------
pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521
View this thread: http://www.excelforum.com/showthread...hreadid=572557