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, ...
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
