Hi All,

I have one column of data that appear in different size blocks, ie one set of data may have 5 rows of cells that contain data, a second block (range) may have 2 rows, a third range only 4 rows of data; the next range 8 rows of cells. There is no fixed sequence of size for these data blocks/ranges and it can vary. However between each set of data cells are 3 cells (contain text and/or formulae) with a number to demarcate the block of data. I need to average each set of data block. Here is a copy of what the data looks like in (say) column F. In column (say) B - I need to insert the average of the values 73.27 to 72.53 (in the first block); 72.54 to 72.62 (in the second block); 75.71 and 74.16 (in the third) and so on. Remember please the number of rows in each block can fluctuate (depending on the initial input of data


1

73.27
72.09
74.45
74.47
72.53

2

72.54
71.49
73.28
72.62

3

75.71
74.16

4

73.56
72.33
72.79
71.40
73.73

I can return the 'last value' in each block by using the formula: =IFERROR(OFFSET(INDEX(F1:F200,MATCH("X",F1:F200,0)),-2,0),""). Where "X" is the text number on its own below the block of data under examination. 200 is the maximum number of data rows.

I have been trying with all sorts of combinations but no real luck yet. Is there anyone out there t help?

Chris