I have the following

name Meals days work-sales
bob....1............1.............3
pete...3.............1............3
jane...2..............2...........5
jill......5.............3.............5
terry..4 ..............1............4

I would like to add a new column that gives a priority column on the
end of the table. The highest priority will be number one and will goto
the person with the highest number of work-sales then days then highest
meals.

The table would look like

name Meals.....days.....work-sales...Priority
bob....1............1.............3...........5
pete...3.............1............3...........4
jane...2..............2...........5............2
jill......5.............3.............5........... 1
terry..4 ..............1............4..........3


I would like to do this using a formula rather than a script


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