average fill

[leecavturbo]

if I have value 1 in A1 and value 4 in A4; A2 should equal 2 and A3 should equal 3.

 

[leecavturbo]

I get problems with that if the start and end value are close like 103 and 107 with 20 cells in between or generally with larger numbers!

same formula but not the result I expected

970
1094.875
1219.75
1344.625
1469.5
1594.375
1719.25
999

 

[gaz_chops]

You need to take the start value from the end value, then divide by the number of cells, excluding the 1st one.

[TABLE="width: 65"]
<!--StartFragment--> <colgroup><col width="65" style="width:65pt"> </colgroup><tbody>[TR]
  [TD="width: 65, align: right"]970[/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]974[/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]978[/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]982[/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]987[/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]991[/TD]
 [/TR]
 [TR]
  [TD="class: xl63, align: right"]995[/TD]
 [/TR]
 [TR]
  [TD="align: right"]999[/TD]
 [/TR]
<!--EndFragment--></tbody>[/TABLE]

=(($A$8-$A$1)/(ROW($A$8)-ROW($A$1))+$A1)

 

[leecavturbo]

brilliant. cheers Gaz

 

[gaz_chops]

You're welcome mate.