Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have been reading the blogs but couldn't really find what I'm looking for.
I'm doing a bank rec, I have 2 sheets. One is our ledger that has 3 columns as follows: A - Date B - Description C - Amount The other sheet is our bank statement. I couldn't match by amount since one amount in the first sheet (ledger) could be split in different amounts and on different dates in the second sheet (bank statement) and vise versa. I'm matching them by the description or text. I want to have a formula that will highlight the descriptions (plus the amounts that matches if possible) that have NO matches. Or is there a specific programming for this. A query program maybe? I hope someone can help me... Thanks a lot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is a bank stock? | Excel Discussion (Misc queries) | |||
Bank Links | Excel Discussion (Misc queries) | |||
Bank Reconciliation | Excel Discussion (Misc queries) | |||
Bank interest | Excel Discussion (Misc queries) | |||
bank cal for interest on cd | Excel Worksheet Functions |