Hi,

I have this sequence of formula:

1 - 4 - AVERAGE(A2:A6)
2 - 3.8 - AVERAGE(A1,A3:A6)
3 - 3.6 - AVERAGE(A1:A2,A4:A6)
4 - 3.4 - AVERAGE(A1:A3,A5:A6)
5 - 3.2 - AVERAGE(A1:A4,A6)
6 - 3 - AVERAGE(A1:A5)


1-6 is just a sequence of numbers and the cell the right, calculates the average but excluding the number in that row.

This is a simplified version of what I have and the cells go from 1 to 230 so I need to drag the formula. No matter what I attempt to do with a $ or such, excel doesn't seem to copy the correct formula sequence. I`m lothed to write the formula by hand 230 times. Can anyone suggest how I can copy and drag down the formula to auto fill and keep the sequence.