Forum Discussion
EXTRACT UNIQUE VALUES IN ONE COLOUMN FROM MULTIPLE COLUMNS IN EXCEL 2016
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
3 Replies
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
Do you have TEXTJOIN() function in 2016? If yes then could use FILTERXML() and TEXTJOIN() together.
See this answer on stackoverflow by me.
- NO BROTHER, THERE IS NO TEXTJOIN() FUNCTION OR FILTERXML FUNCTION IN EXCEL 2016
