Hello
I have a list of 26k rows and 3 cols
col A: Actual day ColB: type of contract Col 3: price
Col A: repeats data so it could say the date for 10 rows and then it will have a row saying total.
I need a code that goes from the bottom of the list up and looks for a blank then inserts the average of all the cells above it untill it hits the next blank.
For example
1: 10
2: 20
3: 40
4: 34
5: 12
6: BLANK
7: 45
8: 14
9: 76
10: 25
11: 99
12: blank
What i need it to do is look at the blank in 12 and calc the average from 7:11 and then move to 6 and calc the blank from 1:5
Obviously this would need to be for 26k pieces of data.
I've got a basic understanding of VBA however, i have no idea how to go about this.
Bookmarks