I would like to compare two columns:
A B C D
John 3Peter 5
Greg 2Greg 6
I would like to see which Names I can not find in Column C that are present in Column A. This is easy, i do that with IF. But I would like to take it further, when there is a match, I would like excel to deduct the Number from Column B from the Number from Column D. For example I would have 4 for Greg (6 minus 2).
"I would like to see which Names I can not find in Column C that are present in Column A" : did you forget to add "in the same row) .
If data is in rows 1 to 4
in D1 copy this formula
copy this formula down.
modify formula for what happens the names inC and A are not the same.
Thanks to venkat1926 for this tip.
This document, titled « Excel - Comparing multiple columns », is available under the Creative Commons
license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM