FinanceTier 320 minintermediate

Remove Duplicate Vendor Payment Requests

Find out how many genuinely distinct vendors sent payment requests, when some are the same vendor typed differently.

What you will learn

• Recognise two emails differing only in case or stray whitespace as the same vendor
• Normalise text into a helper column before comparing it for uniqueness
• Count genuinely distinct values rather than trusting a plain row count

Excel skills

TRIM, UPPER, SUMPRODUCT, COUNTIF · Text Cleanup

The task

Payment requests came in from 30 rows and I know some of these are the same vendor twice, just typed differently - different capitalisation, an extra space, that sort of thing. I need to know how many genuinely distinct vendors sent a request before I process payment runs for each one.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free