johnny4strings
New Member
Hello everyone,
I am really stumped here!!!!
I am working in Excel 2016/365 and am wanting to compare two imports of data and to parse the differences.
Ideally, I would like to bulk copy from the source, then paste data into one tab have a second tab to show me the results of the parsing, or the differences between the two pastes of data in terms of dollar amounts i.e. amounts that had changed. There are headers in the data and the source is a .csv. I would like to rely on a formula as I am not going to be here forever and not many people know VBA.
Please see the example attached for the information with the differencesI have bolded and highlit the differences.
Would I use a vlookup or a match of some kind to get the ideal result? I am focusing on the "amount " in column J as well as the "docket balance" in column K.
Any help would be greatly appreciated, I thank you for your time and of course, effort!
I am really stumped here!!!!
I am working in Excel 2016/365 and am wanting to compare two imports of data and to parse the differences.
Ideally, I would like to bulk copy from the source, then paste data into one tab have a second tab to show me the results of the parsing, or the differences between the two pastes of data in terms of dollar amounts i.e. amounts that had changed. There are headers in the data and the source is a .csv. I would like to rely on a formula as I am not going to be here forever and not many people know VBA.
Please see the example attached for the information with the differencesI have bolded and highlit the differences.
Would I use a vlookup or a match of some kind to get the ideal result? I am focusing on the "amount " in column J as well as the "docket balance" in column K.
Any help would be greatly appreciated, I thank you for your time and of course, effort!
Attachments

10.5 KB Views: 9