Difference from highest in unsorted column

  • Thread starter Thread starter pytelium
  • Start date Start date
P

pytelium

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 |
+-------------------------------------------------------------------+
 
=MAX($A$1:$A$1400)-A1
Fill down to C1400

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| 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?action=getinfo&userid=25521
| View this thread: http://www.excelforum.com/showthread.php?threadid=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 |
+-------------------------------------------------------------------+
 
Back
Top