General

Excel 2007 - A Conditional Formatting ?'s
Frankly I'm very annoyed with conditional formatting in Excel 2007 but am hoping that there are settings or something that will at least take care of the most annoying item so far. Here's what I do and what's happening: - Enter 3 condition formulas for 3 different background colors on a given cell. - Use the... 30 Mar 2010 11:39

Ho do i create drop down list?
I need choices to be saved within drop-down list! "Eduardo" wrote: Hi, look into Debra web she has excellent explanation and examples http://www.contextures.com/xlDataVal02.html "Peter" wrote: Hi, In range A1- A10 i have names. I need to create drop down list for every ... 30 Mar 2010 11:39

SUMPRODUCT with OR condition
There is no need for double multiplying C2:C10. You can use a shorter formula: =SUMPRODUCT(((A2:A10="Bob")+(A2:A10<>"Bob")*(B2:B10="Feb-10"))*C2:C10) Micky "Michael_R" wrote: I have the following table: Name Month Sales Mike Feb-10 1 Bob Mar-10 2 Alex Mar-10 4 Bob Mar-10 8 Bob... 30 Mar 2010 10:32

Formula to look up Min Values in Date with 1 or more criteria
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 reason why I was returned the date from BCD was becos' of my criteria was set to "Name". Is there any way I can check the Name and also limit the minimu... 30 Mar 2010 10:32

Drop down list
When right clicked on a cell there appears an option called 'pick from drop down list',. How to use this feature & does it have any relationship to Data validation drop down list ... 30 Mar 2010 11:39

When automatic page breaks are moved each cell becomes a new page
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 again. -- Please remember to indicate when the post is answered so others can benefit from it later. "K Maree" wrote: Each time I move the auto... 29 Mar 2010 22:32

The Incredible Shrinking Chart
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 2-3 months. (Thousands of employees involved, so the upgrade just has to take as long as it takes.) PROBLEM: Have a workbook with macros and a chart im... 29 Mar 2010 18:07

Caluclating days past due
Frankly, I didn't fully understand your request - however, you may try: =TODAY()-D5 while using the "1904 Date System' ['Tolls' > 'Options' > 'Calculation' tab] Micky "Chris" wrote: I am trying to calculate days past due. For and invoice tracker. I have C5=date invoiced/D5= Payment due/ h5=days pat due.... 29 Mar 2010 14:45

Use icon sets relatively in a pivot table
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 from Quarter 4. If you expand that level of the pivot table you would see the monthly, weekly and daily sales that constituted Quarter 4. But I want to show... 29 Mar 2010 15:52

Pivot table grand total location
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 most column of the pivot table ... 29 Mar 2010 17:00