Rank function

[vmjan02]

I have a table with date, want to work on the rank part. I did tried to use rank.eq, but nu help.

In every date there are diff amount so need to get the rank for every date, any idea or suggestions.

Pl.bll.dte	Advertiser name	Sum of Amt in L			Rank OutPut
20.12.2022	AA	15.7​			1​
20.12.2022	AB	11.7​			2​
20.12.2022	AC	4.2​			3​
20.12.2022	AD	3.5​			4​
20.12.2022	A	3.2​			5​
20.12.2022	B	1.4​			6​
20.12.2022	C	1.3​			7​
21.12.2022	DE	7.7​			1​
21.12.2022	DF	5.6​			2​
21.12.2022	DG	4.3​			3​
21.12.2022	DD	3.8​			4​
21.12.2022	DH	2.2​			5​
21.12.2022	E	2.0​			6​
21.12.2022	f	1.5​			7​
21.12.2022	G	1.4​			8​
22.12.2022	GH	5.1​			1​
22.12.2022	GI	3.8​			2​
22.12.2022	GJ	0.3​			3​
22.12.2022	GK	0.0​			4​

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F
1	Pl.bll.dte	Advertiser name	Sum of Amt in L			Rank OutPut
2	20/12/2022	AA	15.7			1
3	20/12/2022	AB	11.7			2
4	20/12/2022	AC	4.2			3
5	20/12/2022	AD	3.5			4
6	20/12/2022	A	3.2			5
7	20/12/2022	B	1.4			6
8	20/12/2022	C	1.3			7
9	21/12/2022	DE	7.7			1
10	21/12/2022	DF	5.6			2
11	21/12/2022	DG	4.3			3
12	21/12/2022	DD	3.8			4
13	21/12/2022	DH	2.2			5
14	21/12/2022	E	2			6
15	21/12/2022	f	1.5			7
16	21/12/2022	G	1.4			8
17	22/12/2022	GH	5.1			1
18	22/12/2022	GI	3.8			2
19	22/12/2022	GJ	0.3			3
20	22/12/2022	GK	0			4
Main

Cell Formulas
Range	Formula
F2:F20	F2	=COUNTIFS(A:A,A2,C:C,">"&C2)+1

 

[vmjan02]

=COUNTIFS(A:A,A2,C:C,">"&C2)+1

Thanks bro, perfect.

 

[Fluff]

You're welcome & thanks for the feedback.