My main four formulas are:
G9: =SORT(UNIQUE(FILTER(Subdivision,Subdivision<>"")))
H9: =COUNTIFS(Subdivision,G9,New_Construction,H$3,Status,H$4,Days_Closed,"<"&H$5)
I9: =INDEX(SORT(G9:H100,2,-1,FALSE),SEQUENCE(COUNTIF(H9:H100,">0")),{1,2})
I have named ranges Subdivision, New_Construction, Status, and Days_Closed. The formula in H9 is copied down the column. I'd like to reduce the multiple formulas to one formula, and the four columns down to two.
A simplified example is attached.
Test of Sort Unique and Filter and getting occurances count.xlsm
Bookmarks