Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE

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

Brass Contributor

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

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

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

@dsingh2255 

 

Re: List Unique Items

 

 

The free "Professional_Compare" workbook can do that.

Nothing_Left_to_Lose_0-1664027906802.png

 

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

Nothing_Left_to_Lose_1-1664028040528.png

 

 

Download from OneDrive...

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

 

'---

Nothing Left to Lose