Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to i work beyond the Excel limit of a max row of 65,536?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Excel opnening CSV files work properly again. | Excel Discussion (Misc queries) | |||
How do you replace a work sheet in excel with a word document? | Excel Discussion (Misc queries) | |||
Why does "windows in taskbar" not work in excel 2003 | Excel Discussion (Misc queries) | |||
Row limit in Excel | Excel Discussion (Misc queries) | |||
Row Limit in Excel | Excel Discussion (Misc queries) |