ranking without duplicates

[luke11111]

Hi Guys,

Im trying to construct a product comparrison. I want to rank individual products withing their categorys and then their sub groups.
Ive managed to do this with =SUMPRODUCT(--($G$1:$G$43352=G1),--(P1<$P$1:$P$43352))+1 etc but it reutrns too many duplicates so when i use
=INDEX('q3 12'!$F$1:$F$43352,SUMPRODUCT(('q3 12'!$G$1:$G$43352=Sheet1!$D$6)*('q3 12'!$W$1:$W$43352=Sheet1!B12)*ROW('q3 12'!$F$1:$F$43352)),1) on another page it doesnt reutrn the top ten in order. I want to rank them and then be able to call them up by their top tens for comparrison.
Would appreciate any help.
Thanks

[luke11111]

p.s. I also tried =SUMPRODUCT(($D$1:$D$43352=D1)*($P$1:$P$43352-ROW($P$1:$P$43352)/10000>=P1-ROW(P1)/10000)) to get rid of the duplicates, which it did but theres is something wrong with the way the data is being pulled over. The ranking isnt correct. Also the main data is 45000 rows. thanks again

[luke11111]

Dear God Im an idiot.
I put an header in ages ago and didnt realise it put all my data slightly out of sync.
Please dont hold it against me.