@learn2bsmart: 04-sort-filter-CAPTION One formula builds a whole report: SORT + FILTER (Excel 365). =SORT(FILTER(A3:D18,B3:B18="West"),4,-1). Save this for later. #excel #exceltips #filterfunction #sortfunction #dynamicarrays #learnexcel #excel365 #productivity