| Thread | Last Post | Replies |
|
| Total this column | 22 Nov 2007 18:52 GMT | 3 |
I have a column of numbers that look like this. 1805 (1591) 1351 (1078) 1318 (1117)
|
| Excel function query | 22 Nov 2007 16:02 GMT | 2 |
Hi everyone, Somehow i need a formula or something similar which will do the following. Basically, i have a column (A) of cells with different dates in them (e.g. 11/10/07). I then have another column (B) with some blank cells and some
|
| Formulas language issues | 22 Nov 2007 15:50 GMT | 2 |
We work on two different languages on Excel (French & UK). We have issues when opening uk spreadsheets on the french side : when we open the spreadsheet everything is ok. As soon as we save it, all cells containing ATP formulas (Ename, Emonth) switch to "#Name?" status ! We have
|
| VLOOKUP Conversion from Excel 2003 to Excel 2007 | 22 Nov 2007 14:37 GMT | 2 |
I have a large table where the column A is also the lookup column. Basically, I'm doing a moving average over column A. In excel 2003, the following works =VLOOKUP(A264-3000,A:A,1)
|
| How can I increase value in one cell as value in other decreases? | 22 Nov 2007 13:03 GMT | 5 |
In Excel 2003, I would like to find out how to make the value in one cell decrease by 2.18% each time the value in another cell increases by 10%. Thanks. Liz
|
| Adding to a list | 22 Nov 2007 06:10 GMT | 1 |
I looking for a way to add characters to a cell that is part of a list. I have created a list that has several common names and then I want to be able to add charachters to the end of the name Slide (is in the list)
|
| Check box totall | 22 Nov 2007 01:08 GMT | 1 |
I would like excel to total all of the checked boxes in a column, ie how many boxes have been checked in that column. How do I do that
|
| MTD Weekly Cumulative | 21 Nov 2007 23:52 GMT | 1 |
Does anyone have an idea how I can take a group of sales numbers and figure out the MTD Weekly cumulative? I have a worksheet that has the sales figures for each day of a given month. My boss wants to figure MTD weekly cumulative. I am clueless and you all seem ...
|
| Find where a named range is referenced? | 21 Nov 2007 23:20 GMT | 3 |
I have a named range called 'RangesB' and can't remember if I need it or if it us used anywhere in my workbook. Is there any way to find out if & where this named range is used? i.e. in what formulas/cells?
|
| print specific tabs | 21 Nov 2007 23:18 GMT | 1 |
is there a way i can put a button within the first sheet of my workbook that says.. print workbook when doing so, it will print the following tabs notes
|
| Formula Bar blocks column header letters so I can't paste | 21 Nov 2007 21:50 GMT | 3 |
I've run into a problem while trying to move a couple of columns in an Excel 2003 worksheet. I'm trying to move columns J & K a couple of columns over to the right and insert them to the left of column N.
|
| close "ALL" | 21 Nov 2007 21:14 GMT | 4 |
Excel 2002 SP3 Win XP Pro SP2 Hi, Is there a way to "Close ALL Files" (but leave Excel open) with a mouse
|
| Zero is missing from imported file. | 21 Nov 2007 19:13 GMT | 2 |
I import a comma separated value file into Excel 2003, on a regular basis. The file consists of eight columns, one of the columns is just telephone numbers, which all start with a Zero (I am based in the UK), when I import this file into Excel, then the first Zero is missing ...
|
| Remap F2 key function to Enter key? | 21 Nov 2007 18:32 GMT | 2 |
Could someone please tell me how I can set the Enter key to edit the selected cell in Excel 2002? (just like F2 does by default). Much appreciated
|
| Can I auto format row height according to requirements of largest cell in row? | 21 Nov 2007 17:48 GMT | 7 |
I have a worksheet where rows can be either 1, 2 or 3 lines high. I find that on occasion I lose visibility of the end of the contents in some cells because of reductions in row height, or because the contents wrap within the cell.
|