Extract Unique Items from List in Excel - Use DataXL free add-in
🡻 Download the free add-in here 🡻
https://excelkid.com/add-ins/
--------------------
IMPORTANT
--------------------
How to install an Excel add-in?
• Video
How to fix the disappearing ribbon in Excel?
• How to Fix / Enable the Disappearing ...
--------------------
QUESTIONS
--------------------
If you have an issue, don't hesitate to write to us:
https://exceldashboardschool.com/cont...
Our data set contains multiple instances of the same record. How to extract unique values (items) and create a list that only includes unique values? No more time-consuming methods and boring formulas...We’ll show you a quick solution using our free Excel data cleansing tool, DataXL
To do this, follow the steps below:
Go to the DataXL tab on the ribbon.
Select the Range icon.
Choose 'Extract Unique' from the list.
A dialog box will appear.
Add a source range.
Select the output range.
Click OK.
For more advanced Excel solutions and tips, visit our website and subscribe to our youtube channel.