Amend Excel Formula to be used in 2016

[Geo Jul]

Dear All,

Need your help I am using 365 at home and at work most Excel users uses Excel 2010 and 2016
my request is to amend the above formula to be able to be used at work

your assistance is highly appreciated

 

[RoryA]

I'd use a pivot table.

 

[Geo Jul]

I'd use a pivot table.

Many thanks for your response

most excel users at work are not fully aware of Pivot Table

 

[RoryA]

What do they need to be aware of? You create it for them. (you can add some code to refresh it automatically if the data changes.

Your alternative is a load of array formulas pre-entered into enough cells to cope with any possible changes to your data.

 

[Geo Jul]

What do they need to be aware of? You create it for them. (you can add some code to refresh it automatically if the data changes.

Your alternative is a load of array formulas pre-entered into enough cells to cope with any possible changes to your data.

thank you for your remarks