Fairly simple Sort questoin

hudsonhacker

New Member
Joined
Mar 10, 2011
Messages
6
Hi All

I am putting together a spreadsheet to track stats in our baseball league. I have each players stats on sheet 1. I want to rank the players based on their batting average which is in row I. I would like this ranking to show up on a separate worksheet, sheet 2, ranked in descending order. Pretty simple, but I would like it to re-rank every time I change a players stats on Sheet 1. Basically, I want sheet 2 to update and re-rank every time I make a change on sheet 1.

Seems pretty simple, and there are probably a number of ways to do it, would a macro work?
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,109,537
Messages
5,529,424
Members
409,875
Latest member
Khushal Bisht
Top