Forum Discussion
Solved
UNIQUE + FILTER functions returning more results than expected
Hello to all, I am attaching a file which I think is self-explanatory. I am filtering a table data by using two cell parameters but I am getting more results than expected. Can someone please give...
You forgot one bracket
=UNIQUE(FILTER(TRegistos[Item],(YEAR(TRegistos[Data])=$Q$5)*(TRegistos[Origem]=$Q$6)))
oteixeira62 , glad to help. In general try to use formatting, manual one or with Advanced Formula Environment add-in. Like
=UNIQUE(
FILTER(
TRegistos[Item],
(YEAR(TRegistos[Data]) = $Q$5) *
(TRegistos[Origem] = $Q$6)
)
)Hello Sergei and thank You.
This seems to be nice but I cannot install it...Do you have an idea on how to overcome this? It seems I cannot have add-ins from MIcrosoft (this one is free)....
No chance, I have a fully version of Microsoft 365.
Do not understand why I cannot have a simple (free) add-in...