Formula Help

[JakeFromBB]

Hello, I have been trying to generate a formula with no success and am reaching out for assistance. I have simplified my problem to the following. Column A, B, and C are my data and D is the returned results I am looking for. If it is easier to only return one result per group, that also works. Essentially, I would like the system to look in Column A for each "Group" then add the hours (Column B) for each Leader (Column C) in that group and return the Leader with the most hours (Column D).

 

[Fluff]

How about

=LET(u,UNIQUE(FILTER($C$2:$C$100,$A$2:$A$100=A2)),TAKE(SORTBY(u,SUMIFS(B:B,A:A,A2,C:C,u),-1),1))

 

[JakeFromBB]

Mind blown, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.