(no subject)
Dear LazyWeb,
Does anyone know if it is possible, and if so how, in Excel to take a string of numbers from a number of worksheets, and average them automatically? So on day 1 I take readings at 1, 2.30, 4, 5 and 6, day two I take readings at 12, 2.30, 5 and 6, etc, following on for a week. They're all recorded, and I would like to see at the end of the week, what the averages generated for each hour are. For bonus points, I would like them to graph themselves automatically... Any ideas? I know it MUST be possible, but I can't remember how. Ah little worksheets, come and play with me!
I and my research thank you
N.
Does anyone know if it is possible, and if so how, in Excel to take a string of numbers from a number of worksheets, and average them automatically? So on day 1 I take readings at 1, 2.30, 4, 5 and 6, day two I take readings at 12, 2.30, 5 and 6, etc, following on for a week. They're all recorded, and I would like to see at the end of the week, what the averages generated for each hour are. For bonus points, I would like them to graph themselves automatically... Any ideas? I know it MUST be possible, but I can't remember how. Ah little worksheets, come and play with me!
I and my research thank you
N.