Forum Discussion
Solved
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 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
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 Replies
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)), "---") )- Thank you Sergei, it worked perfect.
Best Regards
- GeirHogstad_Raadgivning , glad it helped
