View Single Post
  #1   Report Post  
Wazooli
 
Posts: n/a
Default OFFSET and array formulae

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