Hi Andrew

Thanks for this. It did not quite work how I wanted because the data is a
filtered list and the average comes from the unfiltered list. But there are
two other suggetsions here that do the trick.

Thanks
Dave

"Andrew Taylor" wrote:

Assuming column B contains only the downloaded numbers,
and that there are no non-numeric entries in the list, then
=COUNT(B:B) tell you how many numbers there are (including
the average). So you can get the average from another sheet
with the formula:

=OFFSET(Sheet1!B1,COUNT(Sheet1!B:B)-1,0)

(change Sheet1 to the name of your worksheet)




DaveM wrote:
Hi,

I have a 2 columns of data that is downloaded from an extrernal source. The
list varies in length. At the bottom of the entries in column B is a cell
that calculates the average of all the entries above. The cell to the left is
titled 'Total Average (xxx)' where xxx is the number of entries.

I need to link to the Total Average figure from another worksheet.

I have been using the Index, Match function elsewhere. But because xxx
varies this is not possible.

Can I somehow use the Left function with Index Match such that only Total
Average is the Matched variable? And if so how do I write the formula for
this?

Or can somebody suggest an alternative method?

Thanks

Dave