Forum Discussion
oteixeira62
Jan 31, 2023Copper Contributor
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...
- Jan 31, 2023
You forgot one bracket
=UNIQUE(FILTER(TRegistos[Item],(YEAR(TRegistos[Data])=$Q$5)*(TRegistos[Origem]=$Q$6)))
oteixeira62
Jan 31, 2023Copper Contributor
SergeiBaklan
Feb 13, 2023Diamond Contributor
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)
)
)- oteixeira62Feb 13, 2023Copper Contributor
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)....
- SergeiBaklanFeb 13, 2023Diamond Contributor
- oteixeira62Feb 13, 2023Copper Contributor
No chance, I have a fully version of Microsoft 365.
Do not understand why I cannot have a simple (free) add-in...