Filter a filtered list, returns error when duplicates.

Hi, The idea here is to return the name from the headers when date and project match. I have done a two step filtter. First I filter ther rows, and project names when date match. On that fi...

double filter with duplicates.xlsx11 KB

excel

Formulas and Functions

SergeiBaklan

Jun 25, 2021

Hogstad_Raadgivning

As variant

=LET(area, --(I4=FILTER(Tabell1[[Employee 1]:[Employee 3]],
                        Tabell1[Date]=I3)),
 rws, ROWS(area),
 IFERROR( FILTER(Tabell1[[#Headers],[Employee 1]:[Employee 3]],
                 MMULT(SEQUENCE(,rws,1,0),area)),
          "---")
)

=LET(area, --(I4=FILTER(Tabell1[[Employee 1]:[Employee 3]], Tabell1[Date]=I3)), rws, ROWS(area), IFERROR( FILTER(Tabell1[[#Headers],[Employee 1]:[Employee 3]], MMULT(SEQUENCE(,rws,1,0),area)), "---") )

Forum Discussion

Filter a filtered list, returns error when duplicates.

Resources