Find max of client multiple billing amount for a particular month

[Excelmania21]

Client Month Amount
A November 1234
B November 345
A september 34
A November 456
B December 765
B November 766
A November 988
C January 544

Like this I have 4000 rows, I want to find out which client has max billing amount for november month, considering there are multiple billing amount in that month for that client and there are over 40 clients in the database

I have tried this formula but its not working:

=INDEX(A:A, MATCH(MAXIFS(C:C, B:B, "November"), SUMIFS(C:C, A:A, A:A, B:B, "November"), 0))

 

[NickFru]

Hello - you can try the following,

=MAX(MAXIFS(C:C,B:B,"November",A:A, "A"), ,MAXIFS(C:C,B:B,"November",A:A,"B"),MAXIFS(C:C,B:B,"November",A:A,"C")

 

[Fluff]

Another option

=LET(u,UNIQUE(FILTER(A2:A5000,B2:B5000="november")),TAKE(SORT(HSTACK(u,SUMIFS(C:C,B:B,"november",A:A,u)),2,-1),1))

 

[Excelmania21]

There are more than 40 client names

 

[Excelmania21]

Another option

=LET(u,UNIQUE(FILTER(A2:A5000,B2:B5000="november")),TAKE(SORT(HSTACK(u,SUMIFS(C:C,B:B,"november",A:A,u)),2,-1),1))

What is "u" in this code?

 

[Fluff]

It's just a variable that hold the list of distinct names.

 

[Excelmania21]

What is "u" in this code?

It worked, thank you so much!

 

[Fluff]

Glad we could help & thanks for the feedback.