Flagging duplicates in excel

Monday, July 20th, 2015

Excel is a useful tool in matters such as listing systems which need migration to new domains. Problem is duplication of records.  Rather then sorting and reviewing each entry; why not flag each duplicate found?

  • To do so:
    1. Select the range of cells you wish to test. …
    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.
  • Identifying Duplicate Values in an Excel List | AccountingWEB

    m.accountingweb.com/article/identifying-duplicate-values-excel…/221103
Advertisements

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: