Seamus2626

asked on

# 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.