unique function help

[Hussein_Mohamed]

Dears,

how do i use a unique function to get a data from differen column by excluding column from the function.

Ex) Culumns A- B- C- D and i want to use a unique function for column A, B and D without Column C.

Thanks

[#2 · Accepted solution]

@Hussein_Mohamed 

As variant

=UNIQUE( CHOOSECOLS( A:D, {1,2,4} ) )