Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 66

Row Limitations and Functions

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Limitations of RANK	mvlturner	Excel Worksheet Functions	4	May 9th 06 07:03 AM
Nested Limitations	_Bigred	Excel Worksheet Functions	3	March 16th 06 08:31 AM
Limitations in MS Query?	Jonas Lundqvist	Excel Discussion (Misc queries)	0	December 20th 05 09:45 AM
Excel Limitations??	Mike	Excel Discussion (Misc queries)	1	December 22nd 04 05:39 PM
Vlookup limitations	Dahlman	Excel Worksheet Functions	3	November 19th 04 02:13 AM

All times are GMT +1. The time now is 10:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us