Forum Discussion
EXCEL FILTER
GIVEN CODE "G2" I NEED RESULT SAME AS TABLE 2, NOTE: JAN TO DEC BY ORDER BUT IF SAME MONTH REPEATED, CONTINUE THE SAME MONTH WITH THEIR DETAILS THEN FOLLOWED MONTH BY ORDER K...
Give a try to the following formula-
=DROP(REDUCE("",{"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"},
LAMBDA(a,x,IFERROR(VSTACK(a,FILTER(CHOOSECOLS(B3:D82,3,1,2),(A3:A82=G2)*(D3:D82=x),x)),""))),1)