Filter a filtered list, returns error when duplicates.

[Geir Hogstad]

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 filtered list, I filter the names if the project match.

It works perfect, until I have 2 similar dates. like february second in the example.

Any good ideas on how to solve this

Best Regards

- Geir

[#2 · Accepted solution]

@Geir Hogstad 

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)),
          "---")
)

[#3]

Thank you Sergei, it worked perfect.

Best Regards
- Geir

[#4]

@Geir Hogstad , glad it helped