finding double payments

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

Many thanks

Monique


---
Message posted from http://www.ExcelForum.com/

Check

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


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

Many thanks

Monique


---
Message posted from http://www.ExcelForum.com/