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

 

[kelly mort]

ICT total min rank
34 135 34 11
35 138 35 9
36 141 36 7
37 144 37 5
38 110 34 11
39 113 35 9
40 116 36 7
41 119 37 5
42 122 38 4
43 125 39 3
44 128 40 2
45 131 41 1

 

[AliGW]

What formula are you currently using in the rank column, please?

 

[kelly mort]

=rank(e2,$e$2:$e$20)

 

[AliGW]

Try this:

=RANK(C2,C$2:C$13)+SUMPRODUCT((C$2:C$13=C2)*(B$2:B$13>B2))

Excel 2016 (Windows) 32 bit
	A	B	C	D
1	CT	total	min	rank
2	34	135	34	11
3	35	138	35	9
4	36	141	36	7
5	37	144	37	5
6	38	110	34	12
7	39	113	35	10
8	40	116	36	8
9	41	119	37	6
10	42	122	38	4
11	43	125	39	3
12	44	128	40	2
13	45	131	41	1
Sheet2

 

[kelly mort]

Wow it worked like a magic thank you very much.

Kelly

 

[AliGW]

You're welcome, Kelly!

 

[kelly mort]

So I have a problem here with me again. I want to get pics of my students on their report with a vlookup function. I am done with look up. So wanna ask if it is posible to get the pics on the report. Thanks .

 

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

Link to new thread started for the above request...

https://www.mrexcel.com/forum/excel-questions/1000136-how-show-pics-excel-worksheet.html

 

[kelly mort]

Okay thanks but can you help me with it too?

 

[AliGW]

Kelly - you need to go and post in the new thread linked to in the post above yours.