EXTRACT UNIQUE VALUES IN ONE COLOUMN FROM MULTIPLE COLUMNS IN EXCEL 2016

[dsingh2255]

HI ALL

I WANT EXTRACT UNIQUE VALUES IN ONE COLOUMN FROM MULTIPLE COLUMNS (MORE THAN 3 COLUMNS) BUT FORMULA SHOULD BE ONLY UPTO VERSION 2016 ONLY

NO EXCEL 365 FUNCTIONS, NO VBA, NO POWER QEURY USE,

PLEASE SUGGEST ME GUYZ

[#2]

Do you have TEXTJOIN() function in 2016? If yes then could use FILTERXML() and TEXTJOIN() together.

See this answer on stackoverflow by me.

https://stackoverflow.com/a/66361639/5514747

[#3]

NO BROTHER, THERE IS NO TEXTJOIN() FUNCTION OR FILTERXML FUNCTION IN EXCEL 2016

[#4]

@dsingh2255 

Re: List Unique Items

The free "Professional_Compare" workbook can do that.

The unique list is placed in the first blank area to the right of the data.

Download from OneDrive...

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

'---

Nothing Left to Lose