How to i work beyond the Excel limit of a max row of 65,536?
 

How to i work beyond the Excel limit of a max row of 65,536?
 

joeling, maybe use another column, another sheet, change the way your data
is laid out, wait till the next version???

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"joeling" wrote in message
...

How to i work beyond the Excel limit of a max row of 65,536?
 

Hi Paul, i have same problem with joeling as well, but i think use another
column is
not solve my problem, for example :

i want to compute correlation between two variables with excel
formula CORREL(), unfortunately, my variables contain more than 70.000
rows(which is out of excel rows limitation), so i put those variables in ms
access database. Is it possible if i still use CORREL() but data comes from
ms access database? How? do you have any idea?

thanks
suheryana


"Paul B" wrote:

joeling, maybe use another column, another sheet, change the way your data
is laid out, wait till the next version???

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"joeling" wrote in message
...

How to i work beyond the Excel limit of a max row of 65,536?
 

suheryana, I have never used the CORREL function and I don't use access so
don't know about that, but I tried a sample of data with corral and then
split the data into columns and it came up with the same answer, I took the
data from column A:B and split it to A:D and then used a formula like this
=CORREL(A1:B5000,C1:D5000).

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"suheryana_i" wrote in message
...
Hi Paul, i have same problem with joeling as well, but i think use another
column is
not solve my problem, for example :

i want to compute correlation between two variables with excel
formula CORREL(), unfortunately, my variables contain more than 70.000
rows(which is out of excel rows limitation), so i put those variables in
ms
access database. Is it possible if i still use CORREL() but data comes
from
ms access database? How? do you have any idea?

thanks
suheryana


"Paul B" wrote:

joeling, maybe use another column, another sheet, change the way your
data
is laid out, wait till the next version???

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"joeling" wrote in message
...