Entering data in sheet TB - Column I (CHECK DUPLICATE column) page 25

Located immediately under the column titled CHECK DUPLICATE is the cell 15 which contains a formula. The formula is:

=IF(COUNTIF(INDIRECT("A5: A2000"),A5)>1, "DUPLICATE", "OK")

This formula will check the range A5:A2000 for any duplicate of the account name in cell A5. If it is a duplicate, it will return DUPLICATE, otherwise OK.

Copy down this formula for every row which the corresponding cell in column A has an account name.

Review this column for DUPLICATE item, and delete the row with a duplicate item.

Do not miss copying the formula for a single account.

25