This is an appeal to all Excel users out there. My wife has just lost her job because she didn't satisfactorily complete an Excel task in the allotted time. ...

Why does this time formula *NOT work* if I leave out '(E8D8)'? The formula works normally when written as below... =(E8D8)+E8-D8 When I leave out...

Can auto-filter be engaged for a column, yet not have the pull-down arrow showing? I'd prefer that. Or can one mix advanced filtering and auto-filter? I'm...

Hi All, I need to be able to return an account number (7 digits) from a text string. The account number is preceded by a colon. I'm very familiar with...

Hi, I am still having an issue with a somewhat complex data retrieval/lookup process. Thanks to those who have tried to help. I am setting up a Workbook...

Cell A5 contains the text word TEST Cell C5 contains the formula =IF(MID(A5,LEN(A5),1)="q",A5&"ue","") The result is a "blank" or a "" type of cell...

Everytime I send a query to the newsgroup I get the follow screen: "Communities E-Mail Notification Thank you for taking the time to fill out the...

I have to incorporate this in a IF statement or whatever is simple. Does anybody have a simple solution for this? Cell A1 can have 5 values A,B,C,D or E Cell...

I use some keyboard shortcuts that are global to Windows, e.g. Ctrl+; to generate the letter "ö". This does not work in Excel because Ctrl+; inserts the...

Is there a way to get a formula to return a value instead of an error (#DIV/0, #N/A, etc...) so when I usr that cell in a chart I can get a value at some...

I have a 'hire date' & a 'term date'. I need to calcuate the difference in months & don't want to do the calculations manually. EX. 7/1/06 1/1/06 = 6...

Hi, I have read every questions and replies on this site in order to get my negative numbers to show in brackets and nothing works. I am desparate. ...

please help me in something i have two cells: 31/10/2004 18:00 01/09/2004 07:00 i want to subtract the two cells the result i am taking is 29/02/1900 11:00 but...

I'm currently working with this array formula... =SUM(IF(G4:BJ4C4,C4,G4:BJ4))*0.09615 How do i change this so that G4:BJ4 refers to every 5th cell staring...

Every time I try to format a cell in excel the program crashes on me. I've run a virus check and I can't find any viruses. I seem to have enough space on my...

I have two sheets, and I want to link information from one to the other. The difficulty is that on sheet 1, the data is entered in every consecutive cell down...

For some unknown reason, I cannot download an excel template from MS Office website. This function worked a couple of months ago and now it is not working. I...

ok, my title may not be accurate but I wasn't quite sure what else to call it. I have a workbook created that is a page layout of a bunch of different fields...

Hi, I have column of monthly investment returns. If the return for a particular month is less than zero I want to regard the return for that month as zero but...

Is there any way (in Excel 2003) in which a formula in a locked cell of a password protected worksheet can end up corrupted, without the sheet having first...