I have a table which will expand over time. The end column of the table is an average field which averages the last four weeks data.
The issue I have is that I manually have to amend the 4 columns it looks at each week (as a new one is added). What I would like to be able to do, either automatically or via a macro, is for the sheet to check each cell and if it is empty then ignore it and go through it until it has 4 occurrences i.e.
A B C D E F G
12 14 12 10 120
So column G would be the average of A to D. It would check F and see that is blank, likewise with E and then it would check D, then C etc until it has 4 cells with data.
Is that possible?, Does it make sense
Bookmarks