# Ranking help

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
What would be your expected overal rankings in column H?

trying to set up a ranking for each column of B, D, and F. Then in Column H have a overall ranking just based on adding the rank of columns C, E, and g and divide by 3. If you can think of a better way by all means let me know. Thanks

Giggzz said:
trying to set up a ranking for each column of B, D, and F. Then in Column H have a overall ranking just based on adding the rank of columns C, E, and g and divide by 3. If you can think of a better way by all means let me know. Thanks
Book1
ABCDEFGH
1
2NameAvg Hourly RateRankAvg HoursRankAvg RevenueRankOverall Rank
3Rios, Andre17.912243398.2833
4Rios, Rubin13.384243278.3364
5Ryder, Shawn19.281281570.8411
6Ruiz, Jason15.433281456.3722
7Irizarry, Fern#DIV/0! 0 348.0641
8Hutchins, James#DIV/0! 0 290.4652
9Himes, Richard#DIV/0! 0 207.6572
10Delvecchio, Patsy#DIV/0! 0 16883
11
Ranking

C3, copied down:

=IF(ISNUMBER(B3),COUNTIF(\$B\$3:\$B\$10,">"&B3)+1,"")

E3, copied down:

=IF(N(D3),COUNTIF(\$D\$3:\$D\$10,">"&D3)+1,"")

G3, copied down:

=IF(N(F3),COUNTIF(\$F\$3:\$F\$10,">"&F3)+1,"")

H3, copied down:

=ROUND(SUM(C3,E3,G3)/3,0)

Thank you for the help!!!

Replies
3
Views
1K
Replies
9
Views
562
Replies
9
Views
255
Replies
0
Views
2K
Replies
19
Views
5K

1,203,052
Messages
6,053,223
Members
444,648
Latest member
sinkuan85

### 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