Auto Sort Values From Highest To Lowest Based Off Of Value

**CXP2** · 01-12-2011, 03:49 PM

I need to auto sort values based on ATT with corresponding supervisor from highest to lowest so that I can see at a glance who the top 5 supervisors are that has the highest ATT. please help me with this. I have attached the file, thanks for your help!

**Bob Phillips** · 01-13-2011, 05:19 AM

How about this?

**CXP2** · 01-13-2011, 02:20 PM

Originally Posted by Bob Phillips

How about this?

Yep, the sorting part works.thank you! but i guess what i forgot to tell you guys is that the data changes from time to time. supervisors don't have the same number of agents everytime. sorry about that.

**Bob Phillips** · 01-13-2011, 06:46 PM

The code handles that.

**CXP2** · 02-03-2011, 09:15 PM

Originally Posted by Bob Phillips

How about this?

Hey thanks! It works. I don't wanna be a real pain but could you perhaps explain to me how each part works?i'm trying to copy it to another workbook i created but somehow the formula no longer works.