| Thread | Last Post | Replies |
|
| Formula Question | 28 Aug 2008 18:17 GMT | 4 |
I work on a spreadsheet that has 32 columns - each column represents a day in the month and then there is a month to date total. There are several rows in each column. I enter in the sales figures into each day (column). My boss says there is a formula that will give me a ...
|
| Excel Text Wrapping issue | 28 Aug 2008 17:55 GMT | 2 |
Any time the Text Wrapping is set on a cell the data disappears. If the option is deselected then it reappears. Thanks for any help.
|
| excel sub-par performance | 28 Aug 2008 17:45 GMT | 2 |
Using MS office 2003 + windows XP. When using laptop away from office, excel performance is very poor. Extremely slow = frustrating. If fine when docked at office. Any thoughts about why excel is so slow/underperforming when laptop is
|
| Picture in a cell | 28 Aug 2008 17:25 GMT | 2 |
How can I place a picture in a cell in Excel 2007?
|
| Conditional formatting | 28 Aug 2008 17:23 GMT | 3 |
My conditional formating is not visible. How can I bring it up, so I can format cells using this function. Thanks
|
| Automatic update links to monthly file | 28 Aug 2008 17:01 GMT | 2 |
I have a file (named P04-2009) where the cells need to link to last month's file's cell (same cell) (file named P03-2009). How can I have a macro to automatically update cell to last monthly file automatically when I work on current month file?
|
| Need to display values instead of formula; Ctrl + ` doesn't work | 28 Aug 2008 16:36 GMT | 1 |
I'm helping a co-worker with a VLOOKUP in Excel 2003. I type in a perfectly good formula, and that's all that the cell will display. It doesn't show the results. I searched Excel Help and Google, and the only solution I find is to
|
| Comparing 2 spreadsheets | 28 Aug 2008 16:06 GMT | 1 |
I'm comparing two spreadsheets with a bunch of names on each. I have to find a way to see which names are missing on one spreadsheet to the next. For example, John Smith, John Anderson, and Mike Smith might be on both spreadsheets, but Larry Smith might only be on one. How do I ...
|
| Macro to create multi files from a template with different data | 28 Aug 2008 16:04 GMT | 1 |
I have a template set up to make customer offers in excel with data being pulled in via a vlookup for different projects all of which have different pricing. Each project has a individual ID. To avoid having to manually input the different project ID's I need a macro that will
|
| word wrap & pasted text | 28 Aug 2008 15:43 GMT | 4 |
I have formatted my column for word-wrap but when pasting in text (from Word), the word-wrap is ignored and the text is pasted in one long line, as if over-riding the formatting of the cell. Is there a way to 'lock' word wrap so that it cannot be over-ridden?
|
| Formula changes as new data is entered... | 28 Aug 2008 15:35 GMT | 4 |
I have a master sheet calculating for certain criteria on another sheet. As new data is added to the "other sheet" (it is being inserted each time at row 3)the formula on the master sheet changes to start array at row 4... next time row 5... etc. So it does not include new data ...
|
| Indirect function across sheets | 28 Aug 2008 14:56 GMT | 6 |
If in "Sheet A" I have a formula =sum('Sheet B'!C1:C10) can the indirect function be used on one of the arguments in the sum equation? I can't get it to work so I'm thinking it can't be used to reference another sheet. Is that correct?
|
| 2003 - 2007 | 28 Aug 2008 14:48 GMT | 4 |
I use excel 2003 worksheets that are forwarded to me by company email (Outlook), I enter new data and forward back to the sender with the changes saved as FA1-1, FA1-2 etc. He has 2003, I have 2007 and I save in the 92 - 2003 format.
|
| masking with symbol xxxx | 28 Aug 2008 13:53 GMT | 4 |
hi community kindly can anybody assist me in these task... i hv following numbers sequence and wanted to mask the middle number with symbol xxxx
|
| MAX formula and 'empty fields' | 28 Aug 2008 13:44 GMT | 1 |
I am using the MAX formula - ie MAX of a2,a3,a4,a5,a6 etc. ( These are date fields ) but how do I ensure a blank field is returned if a2-a6 are empty ( rather than 0-Jan-00? Thanks.
|