C
CP
Hi thanks for reading
I have a project where I need to compare month to month data from two sheets
and then make further calulations
Sheet1 = current month
ColA = Client
Colb = Value
Sheet2 = previous month
ColA = Client
Colb = Value
I require sheet1 ColC to show difference in value from previous month
(sheet2) to current month (sheet1) using the value in ColB but also matching
the customer.
If no customer match show a text value "text"
Many many thanks if you can help me
I have a project where I need to compare month to month data from two sheets
and then make further calulations
Sheet1 = current month
ColA = Client
Colb = Value
Sheet2 = previous month
ColA = Client
Colb = Value
I require sheet1 ColC to show difference in value from previous month
(sheet2) to current month (sheet1) using the value in ColB but also matching
the customer.
If no customer match show a text value "text"
Many many thanks if you can help me