Rank by group (3 columns)

[wachiranat]

Hi all,

I have read a lot of the forums to related about rank by multiple criteria, but I still not work for me.

I would like to rank by value sales (column F) based on Shop, Category and Period.

I have already input the expected rank in last column, please kindly help me to solve this.

Thank you in advance.

Book1
	B	C	D	E	F
2	Shop	Category	Period	Value Sales	Expect Rank
3	AA	Soap	Jan	279,038	2
4	AA	Soap	Feb	157,856	2
5	AA	Soap	Mar	817,299	1
6	AA	Soap	Apr	226,370	2
7	AA	Soap	May	700,646	2
8	AA	Shampoo	Jan	4,767	2
9	AA	Shampoo	Feb	417,449	1
10	AA	Shampoo	Mar	38,802	2
11	AA	Shampoo	Apr	817,108	1
12	AA	Shampoo	May	886,953	1
13	AA	Detergent	Jan	929,655	1
14	AA	Detergent	Feb	633,958	1
15	AA	Detergent	Mar	432,569	2
16	AA	Detergent	Apr	479,188	1
17	AA	Detergent	May	113,263	2
18	AA	Softener	Jan	957,692	1
19	AA	Softener	Feb	749,360	1
20	AA	Softener	Mar	253,031	2
21	AA	Softener	Apr	189,820	1
22	AA	Softener	May	532,597	2
23	BB	Soap	Jan	305,398	1
24	BB	Soap	Feb	681,576	1
25	BB	Soap	Mar	108,367	2
26	BB	Soap	Apr	841,704	1
27	BB	Soap	May	879,959	1
28	BB	Shampoo	Jan	514,044	1
29	BB	Shampoo	Feb	155,846	2
30	BB	Shampoo	Mar	827,590	1
31	BB	Shampoo	Apr	359,717	2
32	BB	Shampoo	May	187,742	2
33	BB	Detergent	Jan	257,670	2
34	BB	Detergent	Feb	168,580	2
35	BB	Detergent	Mar	577,112	1
36	BB	Detergent	Apr	12,301	2
37	BB	Detergent	May	286,484	1
38	BB	Softener	Jan	223,749	2
39	BB	Softener	Feb	203,514	2
40	BB	Softener	Mar	864,021	1
41	BB	Softener	Apr	143,021	2
42	BB	Softener	May	763,339	1
Sampledata

 

[Fluff]

Hi & welcome to MrExcel.
How about

=COUNTIFS($C$3:$C$42,C3,$D$3:$D$42,D3,$E$3:$E$42,">"&E3)+1