# Ranking with multiple criteria

#### JolaG

##### New Member
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?

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

#### JolaG

##### New Member
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">

Last edited:

#### JolaG

##### New Member
Excellent, thank you VoG

Replies
7
Views
1K
Replies
8
Views
646
Replies
2
Views
565
Replies
1
Views
317
Replies
11
Views
837

1,190,590
Messages
5,981,816
Members
439,736
Latest member
Nathan20

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back