Hoping someone will be able to help!
In column A and D I have duplicate customer names (Column D has more than A). In Column B I have 2015 Sales Volume and in E I have 2016 Sales Volume.
In column G I want to have a sales variance.
Looking for a formula that will match the customer name then minus the value of Column B against E.
Hope I explained that ok!
Any help would be greatly appreciated.
Cheers
In column A and D I have duplicate customer names (Column D has more than A). In Column B I have 2015 Sales Volume and in E I have 2016 Sales Volume.
In column G I want to have a sales variance.
Looking for a formula that will match the customer name then minus the value of Column B against E.
Hope I explained that ok!
Any help would be greatly appreciated.
Cheers