<

Watch Removing Duplicate Values in a Column in Excel

Posted on
3,367 Points
167 Views
2 Endorsements
Last Modified:
Published
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
How to use a bill paying spreadsheet created by yours truly.  Also a little background.  The download is available towards the bottom of the article and is named Pay-Bills.xltm. Feel free to use, or, as you wish.  Provided as is.
I have seen some great articles online relating to how can we highlight a cell or range of cells based on certain criteria, whether it's using simple conditional formatting or with the help of macro scripts. In this article, I discuss some of these …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month