Thanks for getting back so quick.
The example I've given is more of a visual representation of what I'm after.
Week 1 and 2 is to show how the data would change from each week.
The colour shaded cells are just to show the ranges I would like to select.
I'm trying to enter the formula using Insert\Name\Define then type the formula in 'Refers to:'
All the Ranges will already be named.
I've just been working on the following and don’t think I’m far off using something like:
or
I'm selecting the correct size of the range using the above but need the range shifting down.
The above example is using ‘2’ to group the range by.
Bookmarks