Here's the scenario: A B C 1 10 0 2 20 1 3 30 2 4 40 3 I want to...

Hi, How can I extract the day from the date, ie date is "31/12/04" - need "31" returned in an adjacent cell. I need to have "31" returned as a numeric tho...

This statement returns the correct result for records meeting these conditions and dated before...

Hello I'm trying to write a formula for the following: If the value in cell B8 621 AND if the value in cell B21 3000 value = YES

Is there a method/function to auto hide rows dependent on the value of a cell in that row ... Ie cell B3 = 0 ...... hide row ??! Many thanks again Alan

Hi, I have tried going to Page Setup on an Excel 2003 sheet and changing envelope to 8 1/2X11 sheets. I cannot make it default to 8 1/2 X 11. Every time I...

How do I create a formula to convert inches to show feet and inches (examples, 118.75 = 9' 10 3/4" , 85.875 = 7' 1 7/8")?

Does Sumproduct work with range names or are there restrictions? Like no blanks, etc. When I use range names I get #NUM This is a very helpful group. I even...

I need to count a number of entries that are between two dates where that data is stored in column A and also if the text value in column F is "yes". I have a...

Thanks for all the previous assistance... however I have now encountered another couple of problems Again back to my large spreadsheet issues ... I have...

Hi, I'm sure this is a simple one, but my one remaining brain cell can't see it! My formula currently is:- =COUNTIF('FLYING TIMES'!F4:F22,"W") What I...

Hi Bob please help!!!!! it did not work.This is a example of what I want to do Date In Out Lunch Total Hours...

I am trying to get total of hours worked useing military time.... time start time stop total hours 11:34 16:47 ...

Hello... I am trying to make a spreadsheat that will stop users from entering an entry already entered. I have a Serial # column... these serial #'s can be...

anyone fancy trying to solve an excel problem for me ? i have 5 cells in a row. A B C D Z if there is a value in A and a value in B, then B should appear in...

Having calculated a Trend Line how do I get the trend line data back into a spreadsheet from the chart. ie I've calculated sales over 12 months,...

I have a monthly report from a data warehouse which will have addditional suppliers periodically reported alphabetically - thereby changing the col index no of...

CAN I INSERT ROW OR COLUMN WHILE USING IF FUNCTION THANK YOU

WHY IS MY DATE FORMATTED COLUMN SHOWING A FIVE DIGIT NUMBER? Eg: 24-Nov-04 is showing as 38317