How much data could be entered and search trough

M

Michel

How much data (rows with 10 columns) can Excel 2000 / win98se /
Pentium I 233mhz (used for point-of-sale) hold and be able to search
and sort fast enough, let's say within max 1sec?

Let's say I have 5.000 products in 1 sheet and an other sheet logs all
sales wich can be 300.000 rows within for 1 year. Can I use sort and
find in the 5.000 rows fast enough to work plesant and can I add
300.000 rows to sheet 2?
 
P

Patrick Molloy

a sheet in excel only has 65,536 rows, so 300,000 is out
of scope. You really need to have this data in a database
such as Access or SQL...then extracting data is fast

Patrick Molloy
Microsoft Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching for specific name on main sheet then copying row data associated with name 7
Create if partial match then copy and paste data from one cell to another 1
append multiple worksheets data into a single multi-dimensional array 4
How to filter rows data based on background color of individual cells 3
Search the list of Ids in the records 1
Search the column and return a cell value 15
Excel 2010/2007 - How much can be done with Custom Validation? 7
"collapsing" data--but only for certain rows 1

Top