Skip to main content

Audit duplicate account numbers

100%
COUNTIF

Account IDs are labels, even when they contain digits. A duplicate ID may mean two rows point to the same account, so it deserves attention before a payment file is used.

COUNTIF can count how many times each ID appears in the list. Lock the full account range with dollar signs, then let the individual ID reference move as you fill the formula down.

In C2:C7, count how many times each account ID appears in B2:B7 using COUNTIF and an absolute range.

The grid for this exercise needs a free profile.

Everything above is yours to read either way. 19 exercises stay open with no profile at all.

Adapted from Excel Beginners Practice Lab by Muhammad Auwal Abdulaziz (MIT).