View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dabliss74 dabliss74 is offline
external usenet poster
 
Posts: 1
Default filtration of worksheets tallying 2 million seperate phone numbers

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)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/