1. Get RID of all the merged cells in the results area and in the top part of column D.
2. Delete everything in the area set aside for results.
3. use this in D39.
=LET(A,E7:R29,B,E6:R6,C,HSTACK(FILTER(A,B=D2),D7:D29),TAKE(SORT(FILTER(C,INDEX(C,,1)<>0),,-1),5))
the results spill across and down. Format D39 downwards as %
Bookmarks