have an application where a logger is recording a "reading" every hour and is
downloaded into Excel .. one column shows date and time and other column
shows the reading (24 a day) ... in another part of the spreadsheet,
averaging the 24 readings to get a daily average which are in subsequent rows
for each day so they can be graphed ... if I try to copy the averaging
formula, it only only adds one row to the range ... is there a way of
copying, a function or macro I can write to make the range correct ?
--
GWit