Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Feel free, but not my anti-spam part of my email address.
-- HTH RP (remove nothere from the email address if mailing direct) "Wazooli" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|