Row Limitations and Functions

K

Kirk P.

I need to perform a regression calculation using the LINEST function. The
problem is the dataset is WAY over the 65,000 row limitation. I've got the
data stored in Access. Is there any way to return the calculated values from
the LINEST function (used as an array function) in Excel using the dataset
stored in Access?

There is no LINEST function in Access, so that doesn't appear to be an option.
 

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

Building Non-Contiguous Arrays For Use With Linest 4
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
using linest excel function from msaccess with multidimensional ar 1
LINEST with filtered data 4
LINEST containing selection 0
Template with fields and premade texts.. 0
Help in Median of a quartile 4
Display Coefficients of a Polynomial Trendline 4

Top