OFFSET and array formulae

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Feel free, but not my anti-spam part of my email address.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula setup / OFFSET problem 1
Unexpected (?) behaviour of OFFSET() in array formulas 11
Variable length array that exludes (possible) blanks in the middle 1
Trailing 30 days sum calculation with excel 1
Excel Wildcard in Excel array formula 0
offset off a vlookup? 5
External reference for Offset formula 2
OFFSET Formula 5

Back
Top