View Single Post
  #3   Report Post  
Wazooli
 
Posts: n/a
Default

can i email you a spreadsheet? my data set is 648 entries long...

"Bob Phillips" wrote:

Wazooli,

It would be best to show us some data, expected results, and your formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Wazooli" wrote in message
...
Are array formulae and OFFSET compatible? I have been having trouble

using
them together. I am trying to do an array calculation on two columns,

simply
dividing one by the other to generate an average. The problem is when I

try
to use offset with this, as my data is grouped every 7 cells. Any help is
appreciated.

Wazooli