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

You could sort the data: highlight all the data and go to Data | Sort
and sort by columns G, E and A.

Alternatively, you could use dependent ranking formulae. Chip Pearson
explains how he

http://www.cpearson.com/excel/rank.htm

Hope this helps.

Pete

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

ive added an attachment. ive used rank but some of the priority numbes
have now been duploicated can i get around this?


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