I have a league...

  • Thread starter Thread starter joncurtis199
  • Start date Start date
J

joncurtis199

and have a table (on one sheet) and I wanted to know is it possible to
add a column that shows how much a player has moved up or down after a
sort?



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------
 
joncurtis199 said:
and have a table (on one sheet) and I wanted to know is it possible
to
add a column that shows how much a player has moved up or down after a
sort?



------------------------------------------------


-- View and post Excel related usenet messages directly from
http://www.ExcelTip.com/forum
at
http://www.ExcelTip.com/
------------------------------------------------


Are you doing a manual sort or by Macro?
 
joncurtis199 said:
manual...whats macro...?



------------------------------------------------


-- View and post Excel related usenet messages directly from
http://www.ExcelTip.com/forum
at
http://www.ExcelTip.com/
------------------------------------------------


A macro is a simple way to repeat a series of instructions. Using them will
make your Excel much easier to use.

A quick and easy way would be to use a Macro to determine their position
using the ROW function before the sort, copy the values only to a hidden
column, then do the sort, then finally use ROW again to find their new
positon. Subtracting one from the other will give you the changes.

By doing it this way, you could reduce all this to pressing one button on
the sheet or one Ctrl/Alt combination.
 
Back
Top