Compare Data and Show Differences

[VBA~NOOB]

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.

Thank you

 

[Oeldere]

You could try this one (untested).

=sumproduct(($a$1:$a$50="name")*($b$1:$b$50))-sumproduct(($c$1:$c$50="same name)*($d$1:$d$50))

 

[VBA~NOOB]

Thanks but no go

I have this but I need it to do the math

=IF(VLOOKUP($c3,ded,1,FALSE)="","",(VLOOKUP($c3,ded,1,FALSE)))

 

[Oeldere]

Thanks but no go

In my example it works, so please try again.

E1 contains the given formula and results in 3 (as expected).

A B C D E
Joep 1 Sofie 1 3
Kees 2 Merel 2
Karel 3 Petra 3
Sofie 4 bla 4
Merel 5 bla 5
Petra 6 bla 6

 

[VBA~NOOB]

Thanks but no go

In my example it works, so please try again.


The columns with names have spaces and commas in them. Is that interfering with the formula?

 

[Oeldere]

The name has to be exact to the name in the range.

show some (just a few) data so we could guide you through this problem.

 

[VBA~NOOB]

The name has to be exact to the name in the range.

show some (just a few) data so we could guide you through this problem.

[TABLE="width: 456"]
<tbody>[TR]
[TD]Name[/TD]
[TD="align: right"]20140819[/TD]
[TD]Name[/TD]
[TD="align: right"]20140902[/TD]
[/TR]
[TR]
[TD]Anderson, Kristine B[/TD]
[TD="align: right"]$32.50[/TD]
[TD]Anderson, Kristine B[/TD]
[TD="align: right"]$14.25[/TD]
[/TR]
[TR]
[TD]Anderson, Madeline[/TD]
[TD="align: right"]$25.31[/TD]
[TD]Anderson, Madeline[/TD]
[TD="align: right"]$21.51[/TD]
[/TR]
[TR]
[TD]Anderson, Melissa L[/TD]
[TD="align: right"]$6.40[/TD]
[TD]Anderson, Melissa L[/TD]
[TD="align: right"]$5.11[/TD]
[/TR]
[TR]
[TD]Anderson, Michele L[/TD]
[TD="align: right"]$52.61[/TD]
[TD]Anderson, Michele L[/TD]
[TD="align: right"]$57.34[/TD]
[/TR]
[TR]
[TD]Anderson, Michelle Ann[/TD]
[TD="align: right"]$3.13[/TD]
[TD]Anderson, Michelle Ann[/TD]
[TD="align: right"]$3.17[/TD]
[/TR]
[TR]
[TD]Anderson, Samantha Jo[/TD]
[TD="align: right"]$18.42[/TD]
[TD]Anderson, Samantha Jo[/TD]
[TD="align: right"]$12.53[/TD]
[/TR]
[TR]
[TD]Anderson, Susan L[/TD]
[TD="align: right"]$88.26[/TD]
[TD]Anderson, Susan L[/TD]
[TD="align: right"]$10.94[/TD]
[/TR]
[TR]
[TD]Anderson, Tammy J[/TD]
[TD="align: right"]$1.40[/TD]
[TD]Anderson, Tammy J[/TD]
[TD="align: right"]$1.25[/TD]
[/TR]
[TR]
[TD]Anderson, Teresa K[/TD]
[TD="align: right"]$20.85[/TD]
[TD]Anderson, Teresa K[/TD]
[TD="align: right"]$12.01[/TD]
[/TR]
[TR]
[TD]Johnson, Amy J[/TD]
[TD="align: right"]$25.32[/TD]
[TD]Johnson, Amy J[/TD]
[TD="align: right"]$18.19[/TD]
[/TR]
[TR]
[TD]Johnson, Brandi M[/TD]
[TD="align: right"]$10.92[/TD]
[TD]Johnson, Brandi M[/TD]
[TD="align: right"]$22.59[/TD]
[/TR]
[TR]
[TD]Johnson, Brittany Rae[/TD]
[TD="align: right"]$6.00[/TD]
[TD]Johnson, Brittany Rae[/TD]
[TD="align: right"]$3.75[/TD]
[/TR]
[TR]
[TD]Johnson, Carmen L[/TD]
[TD="align: right"]$29.00[/TD]
[TD]Johnson, Carmen L[/TD]
[TD="align: right"]$45.89[/TD]
[/TR]
[TR]
[TD]Johnson, Christina A[/TD]
[TD="align: right"]$27.31[/TD]
[TD]Johnson, Christina A[/TD]
[TD="align: right"]$24.58[/TD]
[/TR]
[TR]
[TD]Johnson, Corey B[/TD]
[TD="align: right"]$57.77[/TD]
[TD]Johnson, Corey B[/TD]
[TD="align: right"]$64.26[/TD]
[/TR]
[TR]
[TD]Johnson, David William[/TD]
[TD="align: right"]$43.46[/TD]
[TD]Johnson, David William[/TD]
[TD="align: right"]$39.73[/TD]
[/TR]
[TR]
[TD]Johnson, Jill A[/TD]
[TD="align: right"]$9.80[/TD]
[TD]Johnson, Jill A[/TD]
[TD="align: right"]$8.53[/TD]
[/TR]
[TR]
[TD]Johnson, Karen K[/TD]
[TD="align: right"]$6.75[/TD]
[TD]Johnson, Karen K[/TD]
[TD="align: right"]$8.67[/TD]
[/TR]
[TR]
[TD]Johnson, Kelly Jean[/TD]
[TD="align: right"]$11.12[/TD]
[TD]Johnson, Kelly Jean[/TD]
[TD="align: right"]$8.20[/TD]
[/TR]
[TR]
[TD]Johnson, Kevin S[/TD]
[TD="align: right"]$17.50[/TD]
[TD]Johnson, Kevin S[/TD]
[TD="align: right"]$18.45[/TD]
[/TR]
[TR]
[TD]Johnson, Kolleen[/TD]
[TD="align: right"]$10.00[/TD]
[TD]Johnson, Kolleen[/TD]
[TD="align: right"]$29.51[/TD]
[/TR]
[TR]
[TD]Johnson, Lindsay Leigh[/TD]
[TD="align: right"]$81.44[/TD]
[TD]Johnson, Lindsay Leigh[/TD]
[TD="align: right"]$55.99[/TD]
[/TR]
[TR]
[TD]Johnson, Melissa M[/TD]
[TD="align: right"]$39.82[/TD]
[TD]Johnson, Melissa M[/TD]
[TD="align: right"]$32.84[/TD]
[/TR]
[TR]
[TD]Johnson, Michelle Lynn[/TD]
[TD="align: right"]$24.32[/TD]
[TD]Johnson, Michelle Lynn[/TD]
[TD="align: right"]$5.50[/TD]
[/TR]
</tbody>[/TABLE]

link to document https://drive.google.com/file/d/0ByWDiNG3v64TNEF1ZHZDNnpBRWM/edit?usp=sharing

THANKS

 

[Oeldere]

You need to log in to use sharing (so I don't get your excel file)

If the names are always in the same row why not:

e2=d2-b2

 

[VBA~NOOB]

You need to log in to use sharing (so I don't get your excel file)

If the names are always in the same row why not:

e2=d2-b2

I simplified it for the example- the original document is not as neat or clean.

The doc should be able to be edited now (I missed a setting)

https://drive.google.com/file/d/0ByWDiNG3v64TNEF1ZHZDNnpBRWM/edit?usp=sharing

 

[NeonRedSharpie]

I think we're all over thinking this.

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.

Compare:

A1 = C1

Subtract:

D1 - B1

If:

If(A1=C1,D1-B1,0)