Match & Subtract from twi tables
I have attached ss
In tab Attrition Analysis, i am saying 2015-2014 = Growth or Attrition
The problem here is that the two tables in Attrtion Data table may not perfectly align eg KLM is on line 10 in 2014 & line 9 in 2015. Therefore a straight='Attrition Data table'!J10 -'Attrition Data table'!C10 doesnt work.
I need to match by client name and then subtract 2015 from 2014
So a match solution may work?
Thanks
Seamus
EE.xlsx
In tab Attrition Analysis, i am saying 2015-2014 = Growth or Attrition
The problem here is that the two tables in Attrtion Data table may not perfectly align eg KLM is on line 10 in 2014 & line 9 in 2015. Therefore a straight='Attrition Data table'!J10 -'Attrition Data table'!C10 doesnt work.
I need to match by client name and then subtract 2015 from 2014
So a match solution may work?
Thanks
Seamus
EE.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.