• Hot Topics

Excel Compare Data and Show Differences

Hello, I have four columns of data - column "a" has a name column "b" has a dollar amount column "c" has a name and column "d" has a dollar amount. I want to compare the names in column "a" to the names in column "c" and if they match subtract column "b" from column "d" to show the difference. I've tried everything I can think of, but can't get it to work. Any assistance would be appreciated.

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of September 3, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel

privacy policy