There is no need for double multiplying C2:C10. You can use a shorter...

I find that I have to select 3 rows above the row I want to highlight in excel. This carries forward when selecting multiple rows. My mouse is always about 3...

Hi Mike, Sorry to correct my mistake, the formula I used was ={IF(B2="BCD",AL7,MIN(IF($A$2:$A$5=A2,$C$2:$C$5)))} I had used the array formula over it. The...

Hi, not sure what you need and example will help however if you have a column with the 365 days and want to summarize each date with the information entered...

the SUMIF formula should read =SUMIF($A$2:$A$366,D2,$B$2:$B$366) "Michael_R" wrote: Here's how I understand your setup: Column A has 365 dates (01.Jan...

EXCEL 2007 I have just put up a file for you at:- http://www.pierrefondes.com/ - item number 82 (towards the top pf my home page at the time of writing)....

Good afternoon, I doubt the following staff: I know that you can create a Pivot Table apart from others in the same workbook (they share the cache). But I...

Hi Struggling to get this to work, despite looking at the treads. Using excel 2003. trying to count how many times 5710 in col G has "6" in Col H col-G ...

I have a workbook with 12 sheets in it, one for each month of the year. Each sheet has the day of the week in column B, several other values in columns C -- J...

Hi, I'm running a perl script which uses Win 32 OLE package for Excel operations. The script does some processing and populates a spreadsheet, after which...

The culprit is probably just a printer driver. Select a different printer and the auto page breaks should revert from freak-out mode back to normal behavior...

I am sorry but I am still not sure. I know that I need to do a sumproduct but I am unsure of how to set it up. When I select sumproduct it gives me the...

BACKGROUND: We are in the unfortunate situation of having some employees still on Excel 2003/some upgraded to 2007. This will continue for at least another...

When applying the keyboard shortcut CTRL+SHIFT+# to a number, Excel formats that number in the 29-Mar-10 format by default. How do I change that default...

Is there a way to show the grand total column in a pivot table next to the selected fields? Right now, my pivot table shows the grand total in the right...

I need a formula that will translate a percentage change into a word. For instance; if the percentage of cell a1 is negative 5% or greater I want cell b1 to...

I have two drop downs in my spreadsheet one for the product line(IP, DP, Etc) and one for the the period (001/2010, 002/2010, Total Year, Etc. Below is the...

mailing address and return address print directly to envelopes or labels from excel

Hi All! I can use icon sets for certain things, but am unable to figure out how to use them with my existing data. I have a pivot table that may list sales...

I've got a Worksheet template and it's been saved. Now every time I pull it up to work with it the Template Help Task Pane opens up too! I've looked around...