Forum Discussion

oteixeira62's avatar
oteixeira62
Copper Contributor
Jan 31, 2023
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 me a hand on this?

Many thanks,

Octavio

excel

11 Replies

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Feb 13, 2023

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

Resources