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 fi...
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)), "---") )
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
- Geir
Best Regards
- Geir
Hogstad_Raadgivning , glad it helped