I just upgraded to Excel 2007 from Excel 2003. When I open one file from the previous version it does not show the sheet tabs in any mode but the full...

How do I sum with more than one criteria Example: Product Line Period Revenue Dewatering 1 $5,000 Dewatering 4 ...

Hello, Im trying to create a linked multiple drop down list in excel and im not sure if it can be done, such as in the first list of pipe diameter, second...

I want to create a formula to allow me to enter a # into a cell that will display a corresponding months name in that cell. In doing an IF statement I have...

I need to modify a document in Excel but lost the password that is required to unprotect the worksheet so I can edit it. Is there any way to override the...

I need to do a comparison of 2000 records from 1 month to the next. I brought in each months 4 columns of financials. I created formulas to subtract 1...

Please explain how to create an absolute cell reference in Excel 2003? Thanks, Kris

Excel 2003 Sheet1 has one column with 904 records (alphanumeric) Sheet2 has one column with 1069 records (alphanumeric) Both fields have same format (17...

Is there any way to change the font of a cell using conditional formats or a formula that will specify the font? It appears that conditional formats cannot...

dear friends, Someone sent me a spreadsheet with a column for email addresses. Only some of the addresses are clickable links and I thought I'd...

Hi guys, is there a way to convert the following 123456789 to 123-456-789 or abcdefghi to abc-def-ghi I need to convert a long list of serial numbers so I can...

Hello to all! I want to start an inventory cycle count program in my company. How can Excel be used to do random selection? The only data I currently have is...

I've got this workbook with several worksheets. If I open this workbook and close it, the question if I want to save the changes is asked every time. Even if I...

Hi, I'm using a simple formula to find and return the maximum value from 3 compared columns (N, Q & T) and place that max value in column U (same row)....

Regarding WEEKDAY(), I read that problems can occur if dates are entered as text. Based on this, it is understandable that =WEEKDAY(2/14/2008) returns a wrong...

This formula should work: =AVERAGE(OFFSET($B$2,(ROW(A1)-1)*3,,4)) this averages range B2:B5 copying down will automatically change it...

Could someone tell me how to make an Excel spreadsheet to track intermittent FMLA? I do not know very much about Excel, so any help would be...

Hello, I have 2003, I'm trying to color cells that have specific words w/in the cell. I want to count words like "*broke*" and "broken*" as the same to get...