Good evening all, I am looking for some code so that I can increase the Depth of the auto -fliter drop down box, ie to increase the number of entries visible,...

Excel VBA Look Up I have written a macro to look up data from several other worksheets. Now I want to use that summary and create specific reports (by VP,...

Using XL 2000 work 2003 home Need easiest way to formula"ize" the following: Column (A) is the linked-cell value in an XL dropdown box. Column (B) is the...

To count unique values in a column in a range we can use: =SUMPRODUCT((Table!D2:D1000"")/(COUNTIF(Table!D2:D1000,Table!D2:D1000)+(Table!D2:D1000=""))) That...

Hi, I am currently using Excel in Office XP. I have created a small 'Text Box', but have a lot of text in it and I do not want to make the 'Text Box' any...

I have a workbook with several pivot tables that use "Month" for column or row headings. Month is derived with: =INDEX(Months,MONTH(F1),1)&" "...

Morning All, I have to work out the time in which a case has taken to resolve on our system. Now in Excel I have the Case Date (Date opened), Case Time (Time...

INSTRUCTIONS FOR IMPORTING TO EXCEL 2000 AND OUTLOOK 2000. I AM HAVING PROBLEMS COPYING FILES OF A TELEPHONE LISTING TO MY DESKTOP.

I am trying to make a spreadsheet for selecting the appropriate product based on user inputs. When the user inputs certain criteria the spreadsheet should...

Hi, I have a working Excel 2000 app, where users see and manipulate data through forms rather than worksheets. Can you recommend a method of making this app...

I have a VLOOKUP formula below. When the value is zero, I want the result to be blank. What do I do. =IF(A10="","",VLOOKUP(A10,detail,2)) Thnx Prakash.....

Hello, Is there a way to sum in excel based on the color of the cells above it. If there is not a formula for this - is there vba code that could do this and...

Is it possible to compare two different sheets similar to the way the EXACT function compares two cells? I have two sheets that are probably exactly alike,...

I installed Microsoft Money 2003 and now Excel opens "empty" whenever I double-click on .xls or .csv files. It's really painful - I now have to launch...

Excel 2000. I have a worksheet that has some columns I want protected and some others I want to be able to enter / edit . How do I set this up. (I don't want...

I am trying to type the last name "True" and Excel keeps changing the word to "TRUE" in all caps and centers the word in the cell. How do I stop this from...

We occassionally have problems with multiple users being able to open the same worksheet and edit it at the same time. The worksheet is not set to be shared,...

I'm getting a "folder is read only" error when trying to use "save as" to save a file. I can use save as from another computer, logged in to the network the...

I have 3 columns of data. Column A = dates, Column B = numbers corresponding to Column A, and Column C = other numbers corresponding to Column A. The dates...

Ok, I'm sure this can be done and it might have already been posted but this is what I'm wanting to do. I have a spreadsheet of sports cards of a particular...