If I were new to a subject, I would read a book about it and practice the exercises, rather than ask simple questions like: "How do I add the value in cell...

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 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 ...

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...

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 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...

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...

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...

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...

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...

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...

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...

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...

My problem is that I don't know how to connect to an Access database from Excel. I'm modifying a macro in which I have to compare some strings in Excel cells...