If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
finding double payments
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/ |
Thread Tools | |
Display Modes | |
|
|