Forum Discussion
Solved
Calculate difference in numerical value for same unique identifier on two separate data sets
HELP! I'm looking for a quick way to calculate the difference in column C based on a match in column A between the two worksheets. I want to see the change in $$ for each "customer" from one report to the next. The number of rows will change each month based on monthly activity. A friend of mine recommended Index & Match, but I can't figure it out. I hope this makes sense.
That could be
=D2-IFNA(INDEX(February!$D:$D,MATCH(March!$A2,February!$A:$A,0)),0)Please see in attached file
3 Replies
That could be
=D2-IFNA(INDEX(February!$D:$D,MATCH(March!$A2,February!$A:$A,0)),0)Please see in attached file
SergeiBaklan - it worked! I'm going to try altering the formula for the actual data I use and will return if I have any other issues. Thank you so much!
Yes, sure, if there are any questions please ask
