Help with having data automatically sorted in highest to lowest order?

**dsklein85** · 01-11-2012, 10:13 AM

Hi,

Just wondering if anyone could help me with a sorting problem. Basically, I would like to take data from multiple sheets and have them transfer to one master sheet. On the master sheet this data would automatically be sorted from highest to lowest. I attached a very simplistic example of this. Ideally, I would like to scores for each student to transfer to their respective name and sort highest to lowest at the same time on the master list. Thanks!

-Dan

**tom1977** · 01-11-2012, 10:33 AM

hi try this for start

Please Login or Register  to view this content.

**MarvinP** · 01-11-2012, 10:46 AM

Hi dsklein85,

Try using the Indirect Function based on the name in the List Sheet to grab all those scores. Then simply sort the table on the List sheet from high to low.

See the attached for the example.

**dsklein85** · 01-11-2012, 11:33 AM

is there any way for the list to sort automatiically from high to low? Or does this need to be done manually every time?

**micope21** · 01-11-2012, 11:33 AM

On A2 =RANK(C2,$C:$C) then copy down what ever you choose VBA or INDIRECT workbook.

**dsklein85** · 01-11-2012, 11:43 AM

aside from the number rank in column A...is there any way to sort columns B and C automatically from highest to lowest? So the highest score is always on top and lowest is at the bottom.