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
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|