Why don't you just sort them?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"spankydata" wrote
in message ...

Hi
I have a workbook containing colleagues' daily hours worked on separate
sheets. I have then created a worksheet totalling how many hours per
week each person has worked. How do I list the names in order of who
has worked the most hours? I have the names in a row and the hours in
the columns. I think I need some kind of auto sort that will display
the names.
thanks
Steve


--
spankydata
------------------------------------------------------------------------
spankydata's Profile:
http://www.excelforum.com/member.php...o&userid=37217
View this thread: http://www.excelforum.com/showthread...hreadid=569313