Software

Ask something
Question Locked

Excel Formula Question - Autofill

0 helpful
2 replies

by gaunt.sarah

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi there,

I'm a grad student doing a project using weather data and i need urgent help on calculations with my data in excel please.

I have wind speed data for every 10minutes in a column but i need to work out the average for every half an hour. I started off using the AVERAGE function e.g. =AVERAGE(C1:C3) and the next one would be =AVERAGE(C4:C6). I tried to autofill this formala but it didnt work as I wanted it too.. Any ideas please?! It is going to take a very long time to do it manually!

THANKS!

Sarah

2 replies

by absolutely

Sorry about the sarcasm, but I probably know the solution. I just can't tell which one to post, because you haven't clearly stated the question!

:D

What do you want the auto-filled cells to do? What do they actually do?

Please, don't do it manually. Computers exist to do that kind of crap for us.

This discussion is closed to new replies.