Help with Filter and Unique function

[KasperSSI]

Hi,

I saw this Youtube video and wanted to test the part for listing Unique non adjacent rows. Excel FILTER Function TRICK for Non Adjacent Columns - YouTube (around 6 minutes into the vid)
It l

ooks very simple: Unique(Filter(... But somehow I get #value or excel alters the info inside the { }

I tried both with , (commas) and ; (semicolons) inside the { }since i use these in every other formula in my version of excel.
Anyway, neither works.

Any idea of what i do wrong?

Br.

 

[Fluff]

Did you download the workbook & see how the formula is setup?

 

[KasperSSI]

Did you download the workbook & see how the formula is setup?

Yes i just did. Found out it is because My version uses \ instead of commas. Works great. Thanks for the tip ?

 

[Fluff]

You're welcome & thanks for the feedback.