| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to FIND DUPLICATE DEBIT AND CREDITS
I am trying to make a bank reconciliation template. I need to know the
amounts in a column that are duplicates. The duplicates may be a "credit" amount or a "debit" amount in the same column. I would like to mark them both as duplicates. I would like to see for example: A B 1234.00 duplicate 2345.00 3456.00 duplicate 4567.00 -1234.00 duplicate -3456.00 duplicate Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| columns into debit amounts | Excel Discussion (Misc queries) | |||
| I need a formula to find duplicate entries between 2 files. | Excel Discussion (Misc queries) | |||
| formula for debits and credits in EXCEL spreadsheet | Excel Worksheet Functions | |||
| What query isused to add up the credits until it matches a debit? | Excel Worksheet Functions | |||
| Credit and Debit formating | Excel Discussion (Misc queries) | |||
Threaded Mode
