I am currently using this formula "=H19 & I19" in a column to combine two cells adjacent so cell J19 contains the formula for the contents of H19 & I19. So...

I need a formula to change to red on a blank cell or a date that is older than one month from the present date. I am not a techi so please be patient & step...

Why would I show zero's for a column of data in my chart that are actually very large(56869685). Some of my charts have date segments that are missing when...

I have an Excel workbook with multiple spreadsheets - each sheet is one page. I'm trying to print duplex copies and selected 'duplex' in my printer...

I want to make another program run from from excel. Is this possible?

Good afternoon, I have a master worksheet ("parent") for which I need to propagate other worksheets ("child") based on individuals. The master worksheet...

I have been using VLookup in Excel 2003 for some time but I would like to expand the VLookup results. Instead of just copying one cell to paste as the...

Calculated hours and mintues from time; 16:00 (4PM) to 19:30 (7:30PM) is 3:30. How can I convert the results 3 hours and 30 minutes to 3.5 hours?

I need help coming up will a function that will average a range in one column based on if the hours match. Here is my set up. -------A-------B...

Can you specify which series are to be shown in a data table? Currently have a total of 8 different series and only want 4 to show up in the data table.

I have a question regarding links on Microsoft Excel 2003. If I insert a line into the source spreadsheet, the link on the destination spreadsheet doesn't...

We just moved over to 2007, within the last couple of months. Before, in 2003, it appeared that when you saved an existing file, it deleted that file, and...

Hi, I need to be able to insert a new row into a worksheet at row 'x' where 'x' is determined by the value in a particular cell. So e.g. if the user enters...

Good afternoon, I have a master worksheet ("parent") for which I need to propagate other worksheets ("child") based on individuals. The master worksheet...

Up until a few weeks ago all was well with Excel07. Then it started to change the default number format to a date format. When I import a file to excel or...

Hi, Is there a way to filter by a strike through font? Thanks, Ray

=IFERROR(N2,O2),IFERROR(O2,P2),IFERROR(P2,Q2),IFERROR(Q2,R2),"0" I am using this formula in Column I to Check rows N, O, P,Q, and R to copy the dollar amount...

Hi! Columns A and B both have dates entered. Col A is a start date and Col B is an end date. I want the user to filter using a combination of the two. For...

I've been working with a spreadsheet, using different sorts on it. But suddenly one of the columns became a no-op for sorting, whether I sort on that column...

Hi. I have the following data in a worksheet: A B DATE NUMBER 05/15/2010 321 05/16/2010 558...