I have a pivot table set up with 4 drop-down fields. Is it possible to set up these fields so that the selection from the first drop-down restricts the...

I need to match using two columns - this doesnt see to be working: =IF(ISNA(MATCH(I11&J11,'Projected MCE Report Northern C'!I:I &'Projected MCE Report...

Excel 2003, When I copy a group of cells with a formulas in them. The formulas copy and try to adjust to match what they were before. I only want the sum of...

I want to be able to place an x in a column only if three criterias are met: currently in column 0 i have a number of days past due - if column O is between...

I am trying to calculate overtime hours, but I do not know how to program it. Something like: IF B3 = 8, then C3=0 If B3 8, then C3 = Amount Greater...

As best I can tell the future value function only works for even payments. Is there another function, or another way, to calculate FV when you have uneven...

If b2 is 60 and d2 is =0 then g2 = "Bingo" If b2 is 60 and d2 is =0 then g2 = "Bingo" If b2 is 60 and d2 is 1 then g2 = "Sorry" -- Kinghart

I need a formula that will take the amount of "ounces" I put in one range of cells and in another range of cells I need the "ounces" to be totaled. Like...

I need to lookup and insert values from sheet 1 into sheet 2. names are not always alphabetical and can change order. a b 1 name ...

Here is a subset of a group of data that I have: Name Date Dealer Sales Andrea sept-07 A 10 Andrea sept -07 B 14 Tom ...

Hi, How do I write formula for a 8 digit date without / so that it appears as a 8 digit number: ie, 2/12/99 as 02121999? Thanks!

I need to make a form for people to fill in. I want to either highlight the fillable areas or black out everything but the fillable form areas. I do not want...

I have multiple columns in a spreadsheet and I need to count the number times column D contains “TBN� when column L is equal to 1 Thanks. -- JPS

I need to add cells together based on their background color or font color. (I only want to add the cells that are red) How do you do this? I know no...

The following macro works fine in Excel 2003 but generates a compiler error on 2007. Any ideas or direction? Sub WhoRang() Dim ButtonLabel As String Dim...

Hi, I have a simple scorecard that I’ve built with available points in column B and a score in column C. Sometimes not all the column C's are filled out...

I am using excel 2000 and I have a worksheet I am trying to use for projecting completion times and dates on projects. I would like to be able to enter a...

Can anyone help me with a formula to determine a date that will be 10 business days from today's date? I am working on a form and I would like have a cell...

I have a column of numbers that end with an alpha character. I need to remove the alpha character and I'd like to write a macro or formula to do it...

Office 2003 SP3. On all worksheets, my Edit - Delete command is grayed out (unavailable). I can't delete a row or column. None of the workbooks are protected...