Ranking with multiple criteria

[JolaG]

Hi,

I am trying to rank some data using multiple criteria. I have a list of names with a number of skill ratings. The skills are grouped in another column e.g skill A and skill AA belong to group A, skill B and skill BB belong to group B etc. I have a count of the group for each person e.g. resource A has 10 skills in group A, 2 skills in group B and 5 skills in group C. The result of the rank should be 1=group A, 2=group C and 3=group B. I have tried using the formula below but it's not working.

=SUMPRODUCT(($B$2:$B$500=B2)*($T$2:$T$500=T2)*($Z$2:$Z$500<Z2))+1

Can anyone help?

Thank you for your time

 

[JolaG]

Argh!! I can't save the last part of the formula it's...less than Z4))+1

<z))+1" speechmarks)

<z4))+1<z4))+1<z2))+1
<z2))+1
<z4))+1< z2))+1
</z4))+1<></z2))+1
</z4))+1<z4))+1<z2))+1
</z))+1">

 

[VoG]

See http://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html

 

[JolaG]

Excellent, thank you VoG