Jun 25 2021 11:30 AM
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
Jun 25 2021 12:17 PM
SolutionAs 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)),
"---")
)
Jun 28 2021 06:28 AM
Jun 28 2021 02:25 PM
@Geir Hogstad , glad it helped
Jun 25 2021 12:17 PM
SolutionAs 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)),
"---")
)