I would like to orrange the names in order of sales then days work then
priority


name priority days work sales
bob 1 1 3
pete 3 1 3
jane 2 2 5
jill 5 3 5
terry 4 1 4

the results would be

Jill
Jane
Terry
Pete
Bob


Ive been given some tips of the rank function but havnt managed to work
out how best to use it for my purpose.


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=534349