I think you want their ranks. Try this and sort on the column with the
formula...
=RANK(G3,G:G,1)+RANK(E3,E:E,1)+RANK(A3,A:A,1)

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"ceemo" wrote:


I would like to get a priority of names from column B based on the
following

Priority one
column G being the lowest value
than Column E being the lowest value
then column A being the lowest value


please help im stuck with this one


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