| Thread | Last Post | Replies |
|
| condition formula | 08 Mar 2008 13:55 GMT | 5 |
Could someone help me with this condition formula? I need If B10 equals, Boat or a Boat trailer, then add the hours of c10 into d10 I would appreciate any help that you can give me.
|
| Removing Data Validation (Listbox) | 08 Mar 2008 12:35 GMT | 6 |
Is there a way of removing validation from a specific cell after a value is selected from another cell (List). assume I have a validated "Company" list in Column A and the validated "Employees Names" listed in column D
|
| how to use subtract in excel 2003 | 08 Mar 2008 12:09 GMT | 1 |
how to use subtract in excel 2003
|
| Any interactive session on using Excel for doing some calculations | 08 Mar 2008 08:05 GMT | 1 |
Are there any interactive site for where I can master Excel ? They said its a managers best tool and I need to figure out how to use it to do all those calculations of data in all those cells,etc. Thanks
|
| Stop zero on cell | 08 Mar 2008 08:03 GMT | 6 |
How can I stop Excel formula to consider a blank cell as a zero? I have a column with zeros and blank cells. I need the formula to consider the cells with zero as a condition to built the results but excel consider the blanks cell as zero also.
|
| Recover Excel file that was saved over | 08 Mar 2008 05:36 GMT | 8 |
I accidentally saved over a worksheet with another file. Can I recover the original. I have searched and the most recent backup is from Feb. I do not have a system that automatically backs up my files. I have tried auto recovery, restoring the system to a previous date, ...
|
| Where am I going wrong? - Date type function. | 08 Mar 2008 04:43 GMT | 10 |
I'm trying to generate the following title: "Wealth Management - March (current month) 2008(current year)" I'm using the following formula: ="Wealth Management - "&TEXT(MONTH(TODAY()),"mmmm")&" "&YEAR(TODAY())
|
| ISNA match function help | 08 Mar 2008 03:24 GMT | 9 |
Ok, i need some help. I have two columns of data. For one of the columns, i need to find out if its contained somewhere, anywhere in the other column. So how was going to do it was useing an ISNA, Match function and create a new column called
|
| external Excel Add-In reference | 08 Mar 2008 03:16 GMT | 3 |
i wrote an excel function and changed it to an add-in and put into a worksheet and put the worksheet on the network. other users have added the add-in to thier excel. However, when they open the worksheet with the custom add-in, they get an external reference pointing back to ...
|
| Copying Excel formulas from one Workbook to another | 07 Mar 2008 23:47 GMT | 3 |
I have a workbook that has 13 worksheets. One for each month and then one for a tally of all worksheets to get quarterly and ytd totals. I created 5 of these for 5 different depts A user corrupted the 13th summary page in one dept. I want to copy the 13th
|
| conditional formatting | 07 Mar 2008 23:09 GMT | 2 |
I want to write a function that will enter text in a cell if a different cell has yellow fill color. Like this: if cell A1 is yellow then put the text "caution" in this cell that has
|
| do the same thing to multiple hard coded cells | 07 Mar 2008 23:07 GMT | 3 |
How can I repeat a function to multiple cells that are hard-coded with data? For example, I have the following data hard-coded: D ..... H 1 50 42
|
| Rows | 07 Mar 2008 23:03 GMT | 5 |
I have a worksheet with 716 rows and I need to chose every 17th row. I am very new to excel please help me...
|
| how do I merge cells into one then delete the original cells? | 07 Mar 2008 22:59 GMT | 2 |
I'm trying to merge Name cells into one - got it done, but then I need to delete the cells I merged - keep getting the reference error, as I delete the cells that are in the formula
|
| Excel 2002: A few more rows of page tab would be very helpful | 07 Mar 2008 22:55 GMT | 1 |
Dear Sir, The office work in the office require many pages be saved under a single file. This even more convenient when different pages are linked together with formulas.
|