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