more than 65,500 rows
 

not possible.

Mangesh


"frankp23" wrote in message
...

not possible.

I'll bet you can squeeze 36 more in there!

Biff

"Mangesh Yadav" wrote in message
...
not possible.

Mangesh


"frankp23" wrote in message
...

:)

Mangesh



"Biff" wrote in message
...
not possible.

I'll bet you can squeeze 36 more in there!

Biff

"Mangesh Yadav" wrote in message
...
not possible.

Mangesh


"frankp23" wrote in message
...

I doubt the OP just wants to squeeze less than 36 in there...

Mangesh





"Biff" wrote in message
...
not possible.

I'll bet you can squeeze 36 more in there!

Biff

"Mangesh Yadav" wrote in message
...
not possible.

Mangesh


"frankp23" wrote in message
...

Not got huge functionality but if you save a blank workbook as a webpage
with interactivity you will get an OWC spreadsheet (Office Web Component).
This has 262144 x ZZZ (Whatever that is!)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"frankp23" wrote in message
...

Quattro Pro can handle up to one million rows and one million columns.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"frankp23" wrote in message
...

Thanks for all feedback and fun-
I need from 70-110 rows and then ability of prgram to weedout duplicates
which are typically 30% and then a bunch of other analysis.

When I try to filter on unique records I keep getting an eror meddage from
Excell saying data is too complicated when I have toremove duplicates from
50K records.
Even when I have each reord in increasing numerical order- but since it is
alpha numeric in text I think Excell drops the ball.

I bought macro systems Duplicate finder add in to see if it might do the jop
but don't know yet

"Mangesh Yadav" wrote:

I doubt the OP just wants to squeeze less than 36 in there...

Mangesh





"Biff" wrote in message
...
not possible.

I'll bet you can squeeze 36 more in there!

Biff

"Mangesh Yadav" wrote in message
...
not possible.

Mangesh


"frankp23" wrote in message
...

Andy Wiggins wrote...
Quattro Pro can handle up to one million rows and one million columns.
....

Really?! I have QP10 (WPO 2002), and it only goes out to column ZZZ,
which is column number 18,278. FWLIW, WingZ provided 30K rows by
30K columns back in the early 1990s, and most Unix-originated
spreadsheets span at least 512 columns.

Nick Hodgewrote:
Not got huge functionality but if you save a blank workbook as a
webpage
with interactivity you will get an OWC spreadsheet (Office Web
Component).
This has 262144 x ZZZ (Whatever that is!)


Or make a form and drop that OWC (MS Office Spreadsheet 11.0) control
on it. AFAIK, it retains much, if not all, of the normal spreadsheet
functionality. BTW, it's 18,278 columns.

Eugene