Auto Average on next free cell
 

Ive got a worksheet, that i need the following to be done.

Ive been trying all morning to no avail!!

Start at the cell i have currently selected.

Work out the average of all that is above it, up to the next empty
cell. (Like Auto Sum)
Enter the average into the cell.
Move to the next free cell.
Work out the average of all that is above it, up to the next empty
cell.(Like Auto Sum)
Enter the average into the cell.

and so on.

Its doing my nut in, so all help appreciated.

Mark.

Auto Average on next free cell
 

If data consists of all values separated by blanks, try:

1. Edit Goto Special Blanks
2. Auto Sum button (Alt =).
3. Edit Replace "Sum" with "Average".

On 28 Mar, 12:59, wrote:
Ive got a worksheet, that i need the following to be done.

Ive been trying all morning to no avail!!

Start at the cell i have currently selected.

Work out the average of all that is above it, up to the next empty
cell. (Like Auto Sum)
Enter the average into the cell.
Move to the next free cell.
Work out the average of all that is above it, up to the next empty
cell.(Like Auto Sum)
Enter the average into the cell.

and so on.

Its doing my nut in, so all help appreciated.

Mark.