Thread: Average a range within an array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban Alan Beban is offline
external usenet poster
  
Posts: 200
Default Average a range within an array
Norman Jones wrote:
Seems to work. Is it not possible to take the average of the column
items
without looping?

Not AFAIK. Of course, you could use an external function to perform the
work. In this connection, Alan Beban has a range of Array functions
which
may be of interest and which may be downloaded at:

http://home.pacbell.net/beban/
. . .
Regards,
Norman


Thanks for the plug, Norman, but

Application.Average(Application.Index(PeriodicArra y, 0, n))

will return the average of the values in the nth column.

Alan Beban
Reply With QuoteReply With Quote