Archive for July, 2015

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