| Thread | Last Post | Replies |
|
| Countif & Offsets | 15 Feb 2008 21:16 GMT | 1 |
My formula is like that as followed: =COUNTIF(OFFSET(AF:AF, 11,0,128,1),"TRUE") And I got a result as "0". Then I evaluate the formula, it showed "Countif($AF$12:$AF$139, "TRUE") ". This is exactly what I want.
|
| Sort by color "NAME?" error | 15 Feb 2008 20:54 GMT | 5 |
I have tried to sort by color using a VBA. It was successful on one spreadsheet I am working on, but not on another. I keep getting the error message "NAME?", and I don't know why. Any help would be appreciated. Thank you
|
| Add strikethrough button to ribbon | 15 Feb 2008 20:53 GMT | 1 |
In previous version of Excel, I could add a button for "strikethrough" to the toolbar (next to the bold etc buttons). How do I do the same thing in Excel 2007 with the ribbons.
|
| Formula Problem | 15 Feb 2008 20:44 GMT | 2 |
I want to add a group of numbers. If that sum is greater than 0, I want the sum to be multiplied by a number. I need help if anyone can tell me how. Thanks.
|
| Trendline Equations | 15 Feb 2008 20:20 GMT | 4 |
Does anyone know how to extract the trendline formula from a chart object so that the formula is viewable in a cell?
|
| Lookup returning value from antoher column in same row (Text!) | 15 Feb 2008 20:19 GMT | 3 |
I am dealing with two worksheets in a large workbook. For the purposes of public discussion, let's say: Sheet One has a column listing all the characters on The Wire, and a column that is blank or has a description of any beef that the row's character has
|
| formulas & functions | 15 Feb 2008 20:16 GMT | 1 |
I have product items I would like to list in column B rows 3-33, as I add the product name or number I would like the price to be generated in another column. How can I do this
|
| Cell value | 15 Feb 2008 20:08 GMT | 1 |
I have a value in cell A1 of 1 now i want to run various macroes then i want the value to A1 to increase by 1 to 2 then run the same macros
|
| Drop down List w/ Values Pop Automacailly when choose entry from l | 15 Feb 2008 20:04 GMT | 8 |
I want to make a drop down list. I want to make a list w/ a drop down by in a closed different workbook not open workbook. I do not want to create this drop down menu in the same worksheet but in a different workbook.
|
| Program Security | 15 Feb 2008 19:59 GMT | 2 |
I have an EXCEL file which I use for my own use, but I want to 'loan' to a few colleagues at work. I want to keep some control over it - my main worry is that people will copy it, move jobs, take it with them etc., and before long it will have spread. The program has some ...
|
| print spreadsheets only if date has been typed onto it. | 15 Feb 2008 19:47 GMT | 1 |
I have a workbook with mulitple identical worksheets for evaluations. 24 to be exact. Trying to make it easier for the evaluator to use a macro to print only the worksheets that have been typed on. For example, on one day you might do 12 evals then on the next day after opening a ...
|
| NETWORKDAYS formula | 15 Feb 2008 19:43 GMT | 5 |
I have a spreadsheet with the NETWORKDAYS formula on it. It does work perfectly on my computer, but when I use the exactly same file in other computer it does not work. The answer I get is #NAME?. If I do the deduction of the same 2 dates just with the simple formula C2-A2 I ...
|
| coverting h:mm to decimal | 15 Feb 2008 19:42 GMT | 2 |
I have a spreadsheet with several "time" columns. I then bring this data to a pivot table. Before doing that, I have another column set up that converts h:mm to a decimal format (i.e: 3:30 convert to 3.5). I do this conversion with the following formula:
|
| Converting Standard Time into Military Time | 15 Feb 2008 19:34 GMT | 3 |
I have a column of standard times (example 6:50pm) that need to be converted to military times (example 18:50); is there a formula or formatting feature that can convert the entire column?
|
| Converting Standard Time to Military Time in Excel | 15 Feb 2008 19:30 GMT | 2 |
What function can be used to convert a column of Standard Time to a column of Military Time in Excel? Is it a formula or formatting?
|