in the worksheet, a1 to a10 have numbers. I want to calculate to average
value for two value. i.e. average(a1:a2),
average(a3:a4),......average(a9:a10) (no. of average value=5).
If the data range is from a1 to a100, then the above method seems very
unconvenient because no. of averge value=50)

CAN ANY ONE GIVE ME A HELP??

bY Raymond