Finding Duplicates

October 5, 2010

Since Excel 2007 it has been very easy to find duplicates. There are at least 3 ways to do so with this method being the easiest.

1) Select the data where duplicates are suspected

Finding Duplicates

Finding Duplicates

2) Make the selections as per the illustration above

Finding Duplicates

Finding Duplicates

Excel provides some formatting options for the duplicates found and applies the formatting.

So it is a 2 step process to find duplicates. Once identified you may use the filtering or sorting by color in Excel to isolate the duplicates


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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

%d bloggers like this: