Unique Ranking with Multiple Criteria

[chrysti]

This is what I am currently using:
=SUMPRODUCT(--($E$2:$E$30000=$E2),--($F$2:$F$30000=$F2),--($O2<$O$2:$O$30000))+1

I am trying to rank store sales by style by units sold...this is working sort of...it won't break ties...I just want to get to my top 10 to 25

If any one can help...thank you in advance!!!

 

[S.H.A.D.O.]

Thanks Ali.

 

[kelly mort]

Okay Ali thanks.

Back to what you helped me with before.
I added another column to give points based on the score under min and the rank.

I tried to give the first 10 students some points. But it seems I'm trapped. Two students are showing the same points with different rank and min score. I think I need help

total min rank point
242 65 12
244 67 11
246 69 10 25
248 71 9 30
250 73 8 45
252 75 7 50
254 77 6 55
256 79 5 75
258 81 4 85
260 83 3 100
262 85 2 150
264 87 1 150

I used about 57 nested if-and functions to get work done but those 2 conditions became true same time and I'm getting headache.

The criteria for points are
>= 90 250
>= 85 150
>= 80 100
>= 70 85
>= 65 75
>= 60 55
>= 55 50
>= 50 45
>= 45 30
>= 40 25

Then I want the points given when I compare with the rank. The positions are cool but the points is messing up

 

[AliGW]

You can use a VLOOKUP for the points, or a simple LOOKUP function, but what is the purpose of the points? Is it the allocation of the points that you are struggling with? Sorry, but your latest query isn't clear.