Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching 2 worksheets
I have been reading the blogs but couldn't really find what I'm looking for.
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). I'm matching them by the description or text. I want to have a formula that will highlight the descriptions (or amounts) 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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching 2 worksheets
You appear to have 2 posts for this so see your other thread.
-- Regards, OssieMac "melody_ph" wrote: I have been reading the blogs but couldn't really find what I'm looking for. 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). I'm matching them by the description or text. I want to have a formula that will highlight the descriptions (or amounts) 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching across multiple worksheets | Excel Worksheet Functions | |||
Matching Cells on different worksheets | Excel Discussion (Misc queries) | |||
matching two worksheets and return to different value | Excel Worksheet Functions | |||
matching 2 worksheets together | Excel Discussion (Misc queries) | |||
Matching and calculating 2 worksheets | Excel Worksheet Functions |