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)))
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)....