finding double payments

[Monique]

Imagine an excel file with two collumns, the first one contains th
vendor number, the second one the payment amount. The excel fil
contains all payments made for 4 months for a company. Therefore th
first collumn will contain many entries for the same vendor number a
we pay our vendors once a week. Now, it so happened that we somtime
payed our vendors twice. Therefore, what I am looking for is a formul
that will identify double payments, i.e. double entries for vendo
number and payment amount. Can anyone please help me? I've spent hour
to find a solution, but my limited excel knowledge could not help me s
far.

Many thanks

Moniqu

 

[Dave R.]

Check

http://www.cpearson.com/excel/duplicat.htm