Rank based on result of another column

[cadge]

Hey guys, Im trying to rank a list, but i have three different groups, Group 1, Group 2, Group 3, and want it to only rank against others in the same group

IE, What formula would i put into Column C to Get the

Column A......Column B.......Column C

Group 1............5
Group 2............4
Group 1............6
Group 2............5
Group 3............1
Group 1............1

What formula would i put into Column C to Get the results below? Also dont want it to could Zeros


Column A...Column B...Column C

Group 1.........5..........2
Group 2.........4..........1
Group 1.........6..........3
Group 2.........5..........2
Group 3..........1........ 1
Group 1..........1.........1

Thanks in advance

[Fidd$]

Lo there Cadge,

Could you post a sample workbook please? Finding difficulty in understanding what the desired result should be as correlation between data and result not clear.

Cheers

[OnErrorGoto0]

You could use
=SUMPRODUCT(($A$1:$A$6=A1)*($B$1:$B$6<>0)*($B$1:$B$6<B1))+1