priority naming

[ceemo]

I would like to get a priority of names from column B based on th
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 on

 

[Pete_UK]

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 here:

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

Hope this helps.

Pete

 

[Gary L Brown]

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,

 

[ceemo]

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