Formula for third most frequent text with multiple criteria

[Krieg]

I have two criteria (name and month) and I am trying to calculate top-3 most frequent text occurrences in a large dataset. I already crafted the formulas for top-1 and top-2 and they are working well, but struggling to create one for the top-3.

Top-1:
=INDEX(data!$H:$H,MODE(IF((data!$C:$C=$D40) * (data!$W:$W=E$39),MATCH(data!$H:$H,data!$H:$H,0))))

Top-2:
=INDEX(data!$H:$H,MODE(IF(IF((data!$C:$C=$D41)*(data!$W:$W=E$39),MATCH(data!$H:$H,data!$H:$H,0))<>MODE(IF((data!$C:$C=$D41)*(data!$W:$W=E$39),MATCH(data!$H:$H,data!$H:$H,0))),IF((data!$C:$C=$D41)*(data!$W:$W=E$39),MATCH(data!$H:$H,data!$H:$H,0)),"")))

Top-3:
???


Will appreciate any help, if any additional detail is needed, happy to provide it.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LET(u,UNIQUE(FILTER(Data!$H:$H,(Data!$C:$C=$D40)*(Data!$W:$W=E$39))),TAKE(SORTBY(u,COUNTIFS(Data!$C:$C,$D40,Data!$W:$W,E$39,Data!$H:$H,u),-1),3))

 

[Krieg]

Hi & welcome to MrExcel.
How about

=LET(u,UNIQUE(FILTER(Data!$H:$H,(Data!$C:$C=$D40)*(Data!$W:$W=E$39))),TAKE(SORTBY(u,COUNTIFS(Data!$C:$C,$D40,Data!$W:$W,E$39,Data!$H:$H,u),-1),3))

Oh wow, it worked! I didn't even think there is such a clean way of doing this, I thought the only way to accomplish something like this without VBA is ~15 lines of formula code - thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.