Clearing Duplicate Values in Excel

If you ever need to remove duplicate values from large sets of data in Excel, either for translation purposes or data preparation, download ASAP Utilities (free for home use), go to the “Range” section and select options 20 to 22:


I personally prefer option 20, since it leaves 1 original value present and I can then clear the empty rows under section “Columns and Rows”, option 12.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.