UNIQUE and CHOOSE for non-adjacent columns

[Tarek78]

Hi Everyone,

I have an issue with a formula and I have been told we have all the experts in the world to answer to this question.

I am trying to get a list of unique values for 2 non-adjacent columns. I have tried the formula below but it doesn't work. It only spills the result for one single column, not the second one.

I have shown a picture of the result along with the formula used.

Can someone tell me what I did wrong?

Thanks for your help!

UNIQUE From Non-Adjacent Columns

The other day, I was about to create a unique combination of two non-adjacent columns in Excel. I usually do this with Remove Duplicates or with Advanced Filter, but I thought I would try to do it with the new UNIQUE function coming to Office 365 in 2019.

www.mrexcel.com

 

[Fluff]

Change the {1,2} to {1/2}
If that doesn't work use a \ rather than /

 

[Tarek78]

Wow excellent thanks Fluff. How did you know that? Is it a way to specify an array that changed in 365?

 

[Fluff]

No it's just down your settings. In the UK we use a comma for columns & a semi-colon for rows whereas a lot of regions use the / for columns