Atritie exercitiu.xlsm do you have any ideea how i can remove from this context the results of 0 without restricting the area ex: a2:a7, a7 got blanks and because of this the results include 0 (i don`t want to restrict to a2:a6 to solve this).
Atritie exercitiu.xlsm do you have any ideea how i can remove from this context the results of 0 without restricting the area ex: a2:a7, a7 got blanks and because of this the results include 0 (i don`t want to restrict to a2:a6 to solve this).
Alex
Try this,
=SORT(UNIQUE(CHOOSECOLS(FILTER(Sheet4!A2:J7,(MONTH(Sheet4!A2:A7)=MONTH(C2))*(Sheet4!A2:A7<>"")),9,3,4)),2)
Or this:Formula:=SORT(UNIQUE(CHOOSECOLS(FILTER(Sheet4!A2:J7,Sheet4!A2:A7*(MONTH(Sheet4!A2:A7)=MONTH(C2))),9,3,4)),2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks