<

Removing Duplicate Values in a Column in Excel

Posted on
3,363 Points
163 Views
2 Endorsements
Last Modified:
Experience Level: Beginner
2:39
This Micro Tutorial explains how to quickly distill a column of data down to a reduplicated list of unique values, also if the duplicated cells are completely blanks.
2
1 Comment

Expert Comment

by:td1138
I think you meant "deduplicated list of unique values" not "reduplicated list of unique values".
0

Featured Post

PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

It is not that simple from VBA to display a compressed help file as it should be. API calls and a few tricks are needed. This demo and full code will show you how.
Do you want to increase the data integrity of your Excel worksheets?  Do you input something repeatedly?  Would it be handy to pick the item from a predetermined (by you) list?  READ ON!

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month