Forum Discussion
Excel Formula for comparing multiple items then subtracting
I am working on a spread sheet that has multiple items, dates, and I'm trying to figure out a way if numbers changed from one week to the next. Example, In column A I have an item number, column B i...
Maybe you should try using a setup like in the attached sample file. You should be able to use something like this to solve your issue:
Check for Match:
=IF(AND(A2=F2,B2=G2),"Match","No Match")
Difference if Match:
=IF(J2="No Match", "",C2-H2)
Formula Combination:
=IF(IF(AND(A2=F2,B2=G2),"Match","No Match")="MATCH",C2-H2,"No Match")
If my example file is way off base maybe you could provide an example file with a before and after example that shows what you have now and what you expect to see.