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...

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...

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,...

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,...

Jacob, Try changing the 'sum' function in the subtotal bar to 'count'. Or add a formula, for example if the customers are listed in Column A, then in...

I have a very long excel spreadsheet with data like this in each cell: Alaska Native Medical Center 4315 Diplomacy Drive Anchorage,**AK**99508 Phone: (907)...

I have to insert / delete rows or move cells often. When I do this, my "comments" boxes don't move with the cells (they end up all over the place), and they...

is there a way to set up something or even a macro which once i print my sheet, it will erase the numbers which i have in my cells, but not the formulas i have...

I have an excel file which has 7 spread sheets in it. Please tell me how to count total number of words in the file. I need the total and do not need to know...

This problem is happening on my work computer as well as my home computer. When I click on an excel file to open, excel opens but the area where the...

I need help? I have a list of names which need a lot of figures to be entered onto a worksheet. The work sheet is vey large and covers some 7 pages on the...

G'day! Since the USA is supposed to be on holiday, how about rules for what the rest of us will do today? Suggestions to kick off with. 1. Start off with a...

Hi all Please could someone give me a formula that strips out all non-numeric characters from a string variable contained in a cell, and returns a numerical...

I am using Excel 2003 (Office 2003). I am trying to utilize the MROUND function, which should allow me to round to the nearest multiple of a number. However,...

I have set up a worksheet that requires me to update any cells with a background color of yellow. I would like to have the cell return to a white background...

I'm having a problem where the grouping is coming out wrong. I have dates ranging from October 2003 to June 2004. When I group by month, it gives me a...

Hello Everyone, I am trying to write an IF statement that will delete certain rows if they match the false criteria. Ex. IF cells A7:A12=500, if true keep...

Hey Everyone, I have a question about summing via ranges. I am trying to write a macro and have hit a bump. Here is the scenario. I have a 2 columns of data...

The solution for this is probably a quite simple array formula with COUNTIF, but I cannot seem to get it exactly right. All I want to do is take a list with...

I have several tables that use various queries stored in Access as the data source for my Pivot Tables. Question is, after the Pivot Table is set up, is there...