Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
frankp23
 
Posts: n/a
Default more than 65,500 rows


  #2   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

not possible.

Mangesh


"frankp23" wrote in message
...



  #3   Report Post  
Biff
 
Posts: n/a
Default

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
...





  #4   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

:)

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
...







  #5   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

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
...









  #6   Report Post  
Nick Hodge
 
Posts: n/a
Default

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
...



  #7   Report Post  
Andy Wiggins
 
Posts: n/a
Default

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
...



  #8   Report Post  
frankp23
 
Posts: n/a
Default

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
...








  #9   Report Post  
Harlan Grove
 
Posts: n/a
Default

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.

  #10   Report Post  
leaftye - ExcelForums.com
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM
flexible paste rows function that inserts the right number of rows marika1981 Excel Discussion (Misc queries) 1 February 18th 05 02:40 AM
Row selections by row # OR by even/odd rows in another spreadsheet Tom Excel Discussion (Misc queries) 0 February 9th 05 04:03 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 10:56 PM


All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"