Forum Discussion
dsingh2255
Nov 16, 2022Brass Contributor
HOW TO MAKE UNIQUE LIST FROM MULTIPLE COLUMNS WITH EXCEL 2016 FORMULA
Hi All, I want a Unique List from multiple columns into one only with Excel 2016 Version. I have attached dummy file too. in this file i have data in13 columns A to O and I want all unique list ...
dsingh2255
Nov 17, 2022Brass Contributor
yes i know we can achieve the result by power query or excel 365 but thats the limitation of my software it can support upto 2016 excel version.
Riny_van_Eekelen
Nov 17, 2022Platinum Contributor
dsingh2255 But PQ is integrated in Excel2016. Why not use it?