A bit long drawn..
=CHOOSE(INDEX(Misc.!$D$2:$D$13,MATCH(Funds!$G$3,report_month,0)),RANK(K3,K$2:K$191)+COUNTIF(K$2:K3,K3),RANK(L3,L$2:L$191)+COUNTIF(L$2:L3,L3))-1
You could add on other months as per the column to the highlighted as per the columns they appear in
Bookmarks