devioustrap
New Member
- Joined
- May 27, 2010
- Messages
- 2
I have pictures attached which will explain what I'm trying to do better. Sorry for the horrible title, but I've got no idea how to summarize it best.
Basically, I've got two sources of the 'same' data and a column comparing any diferences in their records. Usually, out of the 100ish lines, only 3 or 4 don't match up. That data is then used to make a summary sheet that contains the $ discrepancy and the ID (Cusip) for the transaction.
I want to automate that summary page process. I know I can use an IF type of command (if difference > 0, print the diff, otherwise do nothing) but that'll give me a summary sheet with 100 rows, mostly blank and the differences randomly scattered. Any tips on what I need to be researching to make it so that I only get 4 results like in my summary sheet?
Basically, I've got two sources of the 'same' data and a column comparing any diferences in their records. Usually, out of the 100ish lines, only 3 or 4 don't match up. That data is then used to make a summary sheet that contains the $ discrepancy and the ID (Cusip) for the transaction.
I want to automate that summary page process. I know I can use an IF type of command (if difference > 0, print the diff, otherwise do nothing) but that'll give me a summary sheet with 100 rows, mostly blank and the differences randomly scattered. Any tips on what I need to be researching to make it so that I only get 4 results like in my summary sheet?
Last edited:
