| Thread | Last Post | Replies |
|
| Help on formula | 15 Dec 2006 04:18 GMT | 3 |
I have the following columns: A. Cost B. Plan C. Additional D. Total $100.00 OTN $35
|
| Argh. Please Help | 15 Dec 2006 01:57 GMT | 5 |
How the #@^%$&#^% do I copy a formula from one cell to the next? I've got ten values I want to average, and have the average show in an 11th column. No problem, I can do that.
|
| How to imbed a cell reference in a text field? | 15 Dec 2006 01:02 GMT | 9 |
Is there a way to imbed the value in a cell in a text field? Something like: "Cost at [E7] / hour.", where "[E7]" gets replaced by the value in cell E7. Thanks
|
| Location of certain Excel files | 15 Dec 2006 00:10 GMT | 2 |
I need to reinstall Excel2003 but I have added many micros and specialized toolbars. Does anyone know where this information is stored such that I may saved those files? Thus after I reinstall Excel, I will be able to replace the
|
| Office 2007 - how to make Excell 2007 look like OWC | 14 Dec 2006 21:44 GMT | 2 |
Our company has been using OWC components as front end to query SQL Server Analysis Services cubes. As there is no OWC in New 2007 office release I was wondering if it is possible to use full Excell that is customized to look like Pivot Table. We would build web page where excel ...
|
| Append Data to another sheet.. | 14 Dec 2006 18:59 GMT | 4 |
Howdy all, Ive got a sheet which will have 3 cols of data going down the sheet, It will often have different numbers of rows of information, but id like to append it to a master sheet,
|
| Cell shading based on date conditions | 14 Dec 2006 18:58 GMT | 7 |
I want to shade a column based on a date criteria. The date criteria is entered by the user in column B5 and the day could be other than the 1st. I have 20 columns that display values and the date is displayed as
|
| concatenate cell with text | 14 Dec 2006 17:47 GMT | 2 |
I need to CONCATENATE text: A B C D 1 To Ta (empty) Tu Formula "=CONCATENATE(A1:D1)" doesn't work....
|
| Macro for filling in empty cells in selection | 14 Dec 2006 17:23 GMT | 6 |
I am trying to create a Macro which will look at all cells in a selection, and if the cell is empty takes the value from the top and puts it in this cell (so it should run top-down in a selection). Can anyone help me on this one?
|
| unwrap phase | 14 Dec 2006 16:41 GMT | 4 |
anyone know of a good method to unwrap phase that is wrapped over 180degrees in excel? cheers Phil
|
| Turn off built in smart formatting | 14 Dec 2006 16:37 GMT | 1 |
I am preparing a spreadsheet where certain lines are highlighted. If a few highlighted lines are together it starts to apply that fill color on the new lines when I start to enter data into them. How do I turn this feature off?
|
| Looking for TRIM macro... | 14 Dec 2006 15:10 GMT | 3 |
I'm looking for the code to create a macro that will trim a range or highlighted section of a spreadsheet. I found this once before on the web but can't seem to locate it anymore. Does anyone happen to have this?
|
| Undo Sort Error | 14 Dec 2006 15:02 GMT | 1 |
Hi I hope someone can help with this. I have a spreadsheet that is shared and someone sorted it by the first row only. now all the info is basically useless. is there a way to fix this and prevent sorting just by colums. Oh yes who ever did this saved the
|
| rolling weeks formula | 14 Dec 2006 15:01 GMT | 3 |
I have a sheet that has data in cells A1-A10 and will continue on through A11, A12 etc as the weeks go on and data is added. I want to make a sum of lets say A2-A6 this week, but next week A3-A7 and so on, like a rolling week data.
|
| How to Change fill color of cell based on value | 14 Dec 2006 13:53 GMT | 2 |
I need some guidance on changing the color of a cell when the value is say..< 0:20, and >:30 here is an example of the data in each cell. the format is "h:mm". Thanks for your help in advance.
|