filtration of worksheets tallying 2 million seperate phone numbers

  • Thread starter Thread starter dabliss74
  • Start date Start date
D

dabliss74

Hi, I am a loan officer at a mortgage brokerage. We have
recently put the new nationwide no-call list on an excel spreadsheet.
I
have 2 questions for you. First: is there a way to make excel have
more
rows than 65,536 (preferably like 2 million) as the colorado part of
the
national no-call list is about 2 million. And second;can you tell me
how to
filter one workshet against a second with 30 columns and 65,536
rows(the
filter feature I use only takes into consideration the left-most
column)
 
Excel is limited to 65536 rows. You can have multiple worksheets, but that
isn't really very useful for a database. I think you should import your
data into Access. You can still pull subsets of it from access into excel.
In access, you can easily use one database to filter another. You could
set this up as a query and bring that information into Excel.
 
You must log in or register to reply here.

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

"filtration" of dataset 6
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
Help with combining 2 seperate Worksheet Change Event scripts 2
Check number and return code value 1
compare pairs of columns 3
macro comparing values from 2 worksheets 1
Urgent!! compare 2 columns of numbers for duplicates 2
Calculation slowdown at the bottom of worksheet 5

Back
Top