Hi Jason, I tried what you said but it is being stubborn & continuing to format the wrong cells! Any other ideas I can try??? Much...

I have a workbook with five worksheets. I want to hyperlink to specific cells in each sheet from the first sheet in the workbook. I also want all sheets to be...

I have a worksheet that has many columns, one of which is a model number. I have conditional formated this column, so that if the model number exists in a...

How can I represent negative times in Excel 2000

How can I move last row to second row? When I'm opening excel document it's last row is for example in 58 row but there is now data in there. Is there any way...

Hi, I've a workbook with several sheets. Formula's in one sheet point to other sheets. Is there a way to detect, in a formula, whether the sheet that is...

Can anyone help?? I have a name in cell A1, but I want to split the name into cells A2 and A3. eg, A1 = Simon Thomas, I want B1 to = Simon & C1 to =...

Hi, When I put the formula =month(A1) to get the month for any date, it shows me the right month,numerically. However, when I customise it to "mmm" format ,...

I'm using the following formula, but need to select groups whose names all start with USA but end with different dept names, such as USA-Travel, USA-Resort,...

I'm stuck.... I've got a set of data that contains a range of numbers....I'm trying to come up with a formula that will look at the number, and depending on...

I'm very new to excel so apologies, here is what I want to attempt: I have data in A, B, C, D, E & F the data in E & F will match either A & C or B & D and...

I applied the ACCRINT formula to a security with maturity: 09 Feb 2010 issue: 09 Feb 2005 (adjusted to exclude coupons already paid) first interest: 09 Feb...

How do I get the IF function to do a "not equal to" or "does not equal?" As opposed to the normal =, , , =, =.

How do I get the IF function to do a "not equal to" or "does not equal?" As opposed to the normal =, , , =, =.

I know how to use =RIGHT to separate the last name when there are only 1st and last name. How do I separate the last name when there are 3 or more words in...

How do I get the IF function to do a "not equal to" or "does not equal?" As opposed to the normal =, , , =, =.

Hi, everyone. I have a micro that opens other files to copy data to this file. How can I make it to skip a file that does not exist and continue to the next...

I need a min formula that will give me the minimal value of the cells q1:q76. Cells q1:q12 have vlaues in them, but q13:q76 do not have values because...

I would like to change the background color of subtotal rows in Excel to highlight the rows. I am using the display subtoals function from the menu. I'm sure...

I track individuals training and I have to find a percentage formula that will add up how many people in a colum (of dates) who have completed there training,...