filtration of worksheets tallying 2 million seperate phone numbers #2

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/

0
10/21/2003 4:36:27 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
842 Views

Similar Articles

[PageSpeed] 35

Reply:

Similar Artilces:

Outlook Inbox running tally of e-mails in it
HELP ! This should be simple for someone but not me. I used to have a number on the left side of my screen when in my in-box that would tell me the total number of e- mails in my inbox (normally around 200-300). This was not JUST the new ones which are reflected on the folders line. It was at the bottom of the page and would change immediately if I deleted or added one. I lost the number and want it back. How do I do that? Thanks for any help anyone can give ! Cindy view - status bar "Suzanne" <anonymous@discussions.microsoft.com> wrote in message news:0bb901c3deda$1...

Hidden Rows #2
I am trying to unhide some hidden rows in a worksheet that was sent to me. Rows 1 and 2 are hidden. I've tried the simple route of selecting the entire sheet, pulling down the Format menu, and selecting unhide. I've also tried Ctrl-G (GoTo) and typing in A1. That doesn't work. The document is not protected nor are any of the cells (that I know of). Figz, Two other possibilities: 1) The window has frozen panes, so use windows / unfreeze panes 2) The row height is jsut very very small. Select all the cells using the button to the upper left of cell A1, then right click ...

auto number index snafu
I have a 2003 DB I've been adding to for 2 years. It's at 423 records = now. I export to a PDF for simpler searching and viewing. Using the search the other day, I went to grab DVD 186, on carousel tower= 2. And what came up didn't match the record. The index was totally screwed. I went thru all 423 records and created a numeric index by hand. The auto number field is useless. But I would still prefer an auto number field. Trouble is when I create the auto number field, it's still off the actual numbers of the records.. ie: 99-100 is actually 99-186,187, 188, 189 100-385,...

Forms & Worksheets
I want to create a form in word that will automatically add entered info into an excel worksheet? Is this possible Charlene, Setup you data in ordered columns, with headings in row 1, then menu Data>Form. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Charlene" <anonymous@discussions.microsoft.com> wrote in message news:A8A03DD4-85DB-4F80-B94A-C568FB95531E@microsoft.com... > I want to create a form in word that will automatically add entered info into an excel worksheet? Is th...

Number and Word in the same cell
I want to be able to have a number and a word in the same cell, but still be able to use formulas to add, subtract, ect. to the number. For example: I have 6 meters in cell A1 and want to add 11.9 meters If A1 = 6 meters A2 = 11.9 meters =VALUE(LEFT(A1,SEARCH(" ",A1,1)-1))+VALUE(LEFT(A2,SEARCH(" ",A2,1)-1)) "Bob Martin" wrote: > I want to be able to have a number and a word in the same cell, but still be > able to use formulas to add, subtract, ect. to the number. > For example: I have 6 meters in cell A1 and want to add 11.9 meters An alternativ...

VPN #2
HI, Is there a way to check if one of the ip adress, belong to a VPN??? On 14 nov, 11:12, Simply_Red <Simply.Re...@gmail.com> wrote: > HI, > Is there a way to check if one of the ip adress, belong to a VPN??? If i have all the ip adresses of one pc, is there a way to check if one of them belong to a VPN??? ...

Outlook Web Access #2
I have Exchange 5.5 SP4 and Outlook Web Access installed on the Member Windows NT 4.0 Server. If the regular domain user logs in to Outlook Web Access he can see a list of mail messages but when he opens any of them they look like empty, but actually they are not. If user the member of Administrators Group logs in to the Outlook Web Access he is fine. What should I change? ...

Layaway Report #2
Does anyone out there have a layaway report that has a column for the balance remaining on the layaway? My accountant keeps bugging me for this report; I gave him the Layaway Payment report in CustomerSource, but he really needs a balance column added on to that. Can anyone help me out? Thanks. This is a multi-part message in MIME format. ------=_NextPart_000_0613_01C743D5.2A88EC60 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0614_01C743D5.2A88EC60" ------=_NextPart_001_0614_01C743D5.2A88EC60 Content-Type: text/plain; charset="utf-8" Content-T...

sqlservr.exe process and memory usage #2
sqlservr.exe keeps going up and up all the time on our exchange 2003 box. can I just start and restart the process? How big should it get? What's it used for? I see 4 instances of it. also, Backup exec is on this machine. Thanks for any info on this. I'm trying to figure out what's eating memory up. Thanks. "Bryce" <fukuzz@hotmail.com> wrote: >sqlservr.exe keeps going up and up all the time on our exchange 2003 box. >can I just start and restart the process? You can kill it if you like. It's not used by Exchange. >How big should it get? ...

There is no such object on the server #2
Hi, When i try to go to the properties of my databases in one of my storage groups, I get the error "There is no such object on the server" C0072030 The databases are mounted and I can move mailboxes to them Also, if I click 'ok' on the error message, it brings up the properities sheet for the database, but the public folder store path on the general tab has the pf store name and a guid following it. I have checked permissions to the objects. Does anyone have any suggestions? Any help would be greatly appreciated. Have you tried using ADSIEdit to look at the attr...

Modified Reports security #2
Hello everyone, I was curious of anyone else out there has recognized issues with Dynamics GP 10.0 and Windows Server 2008 recognizing the forward slash (/) to the shared modified forms and reports dictionaries in the Dynamics.set file. We have had issues with not being able to open Report writer unless we change the forward salashes to back slashes. We have also found that one of our Third Party modules' modified reports shows up in customization maintenance but does not show the option to select the modified window in Security. Has anyone else recognized similar symptoms? Thanks...

Antivirus for Exchange 2003 #2
Hi All, Can somebody share some experience about antivirus for exchange 2003 !!! Thanks in advance ! Tedy Scanmail for Exchange 2000/2003 from TrendMicro is the best! "msnews.microsoft.com" <tedybb@yahoo.com> wrote in message news:eyknclULEHA.3428@TK2MSFTNGP09.phx.gbl... > Hi All, > > Can somebody share some experience about antivirus for exchange 2003 !!! > Thanks in advance ! > > Tedy > > Obviously there are a number of vendors out there. But only two you need to look at. Trend Micro, and Sybari. -- Martin Blackstone MVP - Exchange http://...

Web outlook #2
HI all , im having problem with WOA. When i opened a mail then click reply or forward, it closes the window instead of opening it , i can only make a new message . It is happening to all users i restarted the iis admin service and www publishing service too but without success im running exchage 5,5 sp4 and woa is installed on a separate server -- Rick "Rick" <Rick@discussions.microsoft.com> wrote in message news:52E552A4-46A4-4520-8229-EDD9D2A0BD0F@microsoft.com... > HI all , > > im having problem with WOA. When i opened a mail then click reply or > ...

2 copies OEM and have a full version I want to install, or should I?
I bought a new computer that has an OEM version of 2005 installed. I had bought one a few months ago. Should I uninstall the OEM and install the other? thanks bruce Forgot the new one came with Works Suite if that makes any difference There's no difference between the OEM and Retail versions so no need. -- Regards Bob Peel, Microsoft MVP - Money For UK tips & fixes see http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny. For wishes or suggestions see http://register.microsoft.com/mswish/suggestion.asp or for UK wishes http://www.microsoft.com/uk/support/money/feedbac...

Voucher Numbers on Payables Recurring Batch
Hi all, Is there a way to modify the length of the additional incremented number that is added becuase of posting a recurring batch? For example, if the voucher numbers are V0000075 and the first time you post it in a recurring batch, the voucher number becomes V0000075000000001, second post in a recurring batch is V0000075000000002, and so on. We want to shorten the lenght of the voucher number to something like V00000750001. Please let me know if you know where to change the length. Thanks! There is no way to accomplish this without a customization. After all, Dynamics GP ...

How To Get 1 Million Visitors On Your Web Site
How To Get 1 Million Visitors On Your Web Site Without Paying A Dime In advertising ! Click here : http://www.freeadguru.com/cgi-bin/i.pl?c=a&i=16649 Are you frustrated by the lack of traffic coming to your site? If I would tell you that after months of research, I just got my hands on the most hidden secrets... Pssttt, yes precisely those secrets that the wealthy webmasters are using now to get their millions of hits every day. And let me tell you, it works... It's incredible to see all the knowledge they possess...they even have very sneaky tricks ! These well guarded ...

=?gb2312?B?0MLOxTq5xbato6gxOTEyLTE5NDmjqcPxufq0ybLouvg1Mjiw0aGitMnG9zQwMLz+x+u528nNo6FOZXdzLEFudGlxdWUgKDE5MTItMTk0OSkgUG9yY2VsYWluIFRlYXBvdCA1MjggQ2hpbmF3YXJlIDQwMCxJbnZpdGF0aW9uIFZpc2l0IQ==?= #2
0MLOxTq5xbato6gxOTEyLTE5NDmjqcPxufq0ybLouvg1Mjiw0aGitMnG9zQwMLz+LMfrudvJzaOh Ck5ld3MsQW50aXF1ZSAoMTkxMi0xOTQ5KSBQb3JjZWxhaW4gVGVhcG90IDUyOCBDaGluYXdhcmUg NDAwLEludml0YXRpb24KVmlzaXQhCsfrteO798341b6jqFBsZWFzZSBjbGljayBXZWKjqaO6aHR0 cDovL3d3dy54ang1ODguY29tCtC70LujoQpUaGFua3Mgo6EK0Oy9qNDbCkppYW54aW9uZyBYdQq1 2CAgINa3o7rW0Ln61eO9reHT1t3K0ApBZGRyZXNzo7pTaGVuZ3pob3UgWmhlamlhbmcgQ2hpbmEK ...

Configuring Outlook #2
Hai, I have to configure my outlook while working in my system everyday. I'm not able to view my mails which are sent to me the previous day or week. Please help me how do i configure my outlook in such a way that I get my mails regularly without any difficulty. send me a reply as soon as possible. regards, Solomon ...

Page Layout Question #2
Hello, I am trying to create a publication that has page sizes of 8.5 w x 5.5 h. Each page should have a to pmargin of 0.75 in and 0.50 everwhere else. I have done that and it seems to work fine, except when I print it. I would like to save paper and put two of these pages on 1 physical piece of paper. It should fit fine, but what Publisher 2007 does is to print double pages. Meaning that on the first piece of paper I get two publication page 1's (each taking up half the page) instead of getting publication page 1 and publication page 2 on the 1st piece of paper. My layout type is...

Seperating Data within cells
I have a huge data file with colums contain data that need to be seperated The data was entered into the cells 2#5#8# etc. (numbers can range from one to 38). I need to get all the 2's into a colum all the . 3's, 4's, 5's... and they all need to line up. I am trying to figure out how to do this since one cell may start with one number and then next cell a different one? Please help! I hope this makes sense. Perhaps try using Data > Text to Columns with delimiter: # ? Select the column Click Data > Text to Columns Check "Delimited" > Next In St...

when writing an IF statement what is the syntax for "Not Equal to. #2
what is the syntax for writing an If statement for NOT EQUAL TOO Use <> for not equal to. Example: =IF(A1<>32, "error",A1) "NEEDTOKNOW" wrote: > what is the syntax for writing an If statement for NOT EQUAL TOO ...

Printing
I need to print sheets from around 25 workbooks in excel, this can b pretty time consuming.....the problem is i found a macro that woul print the first sheet in all the workbooks, whithin a folder.... i nee to specify which sheet i need printing, i.e some workbooks have severa sheets -- Message posted from http://www.ExcelForum.com Hi sosteffo Do you know the name of each sheet you want to print in each workbook? -- Regards Ron de Bruin http://www.rondebruin.nl "sosteffo >" <<sosteffo.148q5f@excelforum-nospam.com> wrote in message news:sosteffo.148q5f@excelforum-n...

sumproduct if #2
i need a "sumproductif" function:, a combination of sumif and sumproduct e.g. i need to sumproduct values in columns A and B if a condition in column C holds does anyone know of anything that would do this?? Hi SUMPRODUCT will allow multi-criteria whereas SUMIF only allows one criteria. Now if I understand rightly, you have one criteria and several columns to add. In which case you may add several SUMPRODUCT together. HTH Cordially Pascal "sumproduct if" <sumproduct if@discussions.microsoft.com> a �crit dans le message de news: AAA86B2C-DC4F-49EA-9E1E-5275...

Colouring in areas within a shape (Part 2)
Perhaps it would have helped if I'd actually typed something in before hitting [Enter] but here goes... This kind of carries on from my previous post about triangles, but, for example, having drawn a line that vertically bisects an autoshape triangle, is there any way in which I can colour the left hand side of my triangle in one colour and the right hand in another? Thanks again Pete Peter Rooney <PeterRooney@discussions.microsoft.com> was very recently heard to utter: > This kind of carries on from my previous post about triangles, but, > for example, having drawn a li...

Pictures #2
How do I see pictures on incoming messages directly on the e-mail and not as an attachment? (outlook 2002) You can't. -- Patricia Cardoza Outlook MVP www.cardozasolutions.com Author, Special Edition Using Microsoft Outlook 2003 Author, Absolute Beginner's Guide to OneNote 2003 ***Please post all replies to the newsgroups*** "Slyke" <anonymous@discussions.microsoft.com> wrote in message news:10a301c42622$73e61aa0$a001280a@phx.gbl... > How do I see pictures on incoming messages directly on > the e-mail and not as an attachment? (outlook 2002) Really???. I c...