Identifying Duplicate Values in an Excel List

Image

Identifying Duplicate Values in an Excel List

1. Select the range of cells you wish to test. One way to do so is to click on a single cell and then press Ctrl-A.
2. On Excel’s Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values.
3. Click OK within the Duplicate Values dialog box to identify the duplicate values.
4. Duplicate values in the list will now be identified

Advertisements

About amr2008

Welcome there, Amr Abdel-Aziz, CEO Founder, Ultras Business "لنكن التغيير الذي نريد أن نراه فى العالم"

Posted on March 20, 2013, in Social Media and personal branding and tagged , , , . Bookmark the permalink. Leave a comment.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: