Extract Unique Items from List in Excel - Use DataXL free add-in

Опубликовано: 20 Октябрь 2024
на канале: Excel Bootcamp
7,476
29

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.