| Thread | Last Post | Replies |
|
| Indirect & Arrays | 12 Feb 2008 17:55 GMT | 4 |
Am I being thick... I can not get an array formula to work with an indirect command. I may have made a typo but I am now starting to convince my self it doesn't work.
|
| Office licensing | 12 Feb 2008 15:24 GMT | 2 |
A staff worker at our office has a laptop for work at home. Can she use the license form her office pc at her home laptop too? I vaguely remember some similar terms a few years back. Could someone please clarify this? Thanks
|
| Date Calculation | 12 Feb 2008 15:19 GMT | 2 |
I know you have probably answered this question before but here it is again. I have a document that I am trying to make easier to fill in (weekly we have to make upwards of 182 different documents). I have seven fields that I need to put the dates into starting with monday
|
| sumif formula in Excel 2003 | 12 Feb 2008 14:43 GMT | 4 |
I opened a spreadsheet that I have not used since I changed to Excel 2003. When I try to copy a "sumif" created prior to Excel 2003, the formula is there but it does not calculate correctly. Also, when I "edit" the formula, I get the green triangle in the upper left corner of ...
|
| Change Cell color with macro | 12 Feb 2008 14:33 GMT | 6 |
I was wondering if anyone could help me out with this. I want to be able to change the background and font color of any cell where text is equal to a specific text. I do not know if I have the right syntax, but here goes
|
| Merge 2 cells | 12 Feb 2008 10:52 GMT | 3 |
I have formated 2 Text columns to General and tried every which way to merge the cells into one. A1 would be "Style" B1 would be "335B". Cell C1 is formated as general. The formula in cell C1 is =A2&" "&B2. No matter what I do it only displays the formula.
|
| Displaying non-English characters | 12 Feb 2008 10:32 GMT | 1 |
I have a .csv file whic have the following characters N°UAI N°SIRET N°FINESS but are being displayed like this N°UAI N°SIRET N°FINESS
|
| Format Cells Date (or any change) not working on imported data | 12 Feb 2008 09:49 GMT | 3 |
I've just spent ages researching this and not come up with what I need to be able to do. I have a worksheet for some simple data that has been imported, a date, text and number column (as they display graphically to the end
|
| Conditional Format if cell value is odd | 12 Feb 2008 06:48 GMT | 22 |
Does anyone know how to do this? Thanks a bunch, Michele
|
| Missing Graphing Functionality | 12 Feb 2008 02:17 GMT | 2 |
In Office 2003, I used to be able to select the following when formating a data series in a graph: fill effects | shadows This would basically give me shadows on the left/rigt sides, etc. This does
|
| Can an animated GIF be inserted into an Excel97 sheet? | 12 Feb 2008 00:19 GMT | 2 |
I've done some Excel Help and googling and the answer seems to be no can do. Just checking to see if anyone's ever found a way to insert an animated GIF into an Excel97 sheet? Thx.
|
| Help; ther's got to be a better way :-( | 12 Feb 2008 00:12 GMT | 5 |
I have several reports that export into .xls spreadsheeets from SAP. They always export with multiple header lines which makes it hard to sort because doing 'Data>Sort>w/ Header' only keeps the top line as header. I need to keep them all for my boss.
|
| COMBIN and listing - Help Required Please. | 11 Feb 2008 23:25 GMT | 4 |
I am looking for some assistance to achieve the following which I would prefer if possible to be able to carry out by using formula functions rather than macros which are not my forte. I have used the COMBIN formula to achieve the figures I require,
|
| count like numbers | 11 Feb 2008 23:14 GMT | 3 |
I would like to count the like numbers in a given set of numbers. If row 10 is different than row 9, it returns 1. If row 12 is the same as row 11, it returns 2, and if row 13 is the same as 11 and 12 it will return 3. (the count would never go beyond 5). For example, the left
|
| what happened to the rest of the columns and rows? | 11 Feb 2008 22:40 GMT | 1 |
Using Excel 2002, I opened a file that contained a chart. The rows and columns extend only as far as the chart extends. Maybe 50 or so rows and 30 columns are visible. The rest are gone. How do I get them back? Thanks,
|