| Thread | Last Post | Replies |
|
| Problem with SMALL Function | 11 Jan 2007 16:17 GMT | 5 |
I am having a problem with the SMALL function in Excel. I've written a simplified example of the problem I'm having: Example A
|
| Excel 2003 - where is custom toolbars? | 11 Jan 2007 15:09 GMT | 4 |
I'm using Excel 2003. I need to copy the customize toolbars from my pc to my laptop. I can't find the file *.xlb in my pc. Where is custom toolbars located? Thanks.
|
| Labeling 1st through 11th place | 11 Jan 2007 14:59 GMT | 1 |
I have an excel file that has 11 place standings and I want a column to look at another column and label who has 1st, 2nd, 3rd, etc... How would I go about doing that? I can get it to find the largest or smallest number in the set but no the other ones. I want it to update
|
| Lookup row, dependant on cell value? | 11 Jan 2007 14:19 GMT | 2 |
I have a sheet, as per the example. I need to insert into column A the quantities, depending on the value a specfic cell. I.e if week 2 is entered, the column A should read, 12,5,2,3,3,3 and if Week 1 is entered 5,3,2,3,2,2 etc
|
| Counting (with filter) formula | 11 Jan 2007 13:39 GMT | 4 |
I'm wondering if there's any formula / another way to have a formula that calculates number of rows in another sheet with specified filter conditions. Eg. in sheet1 / cell A1 I want to have a number of rows in sheet2 where Z column value is higher than 2, and cell A2 = number of
|
| amending an EXCEL worksheet | 11 Jan 2007 08:08 GMT | 3 |
Firstly I have a worksheet with an array of single letters in each cell (they are grades for subjects in a school). I need to create a parallel worksheet where the letters are one grade higher than those in the original worksheet, i.e. if in cell A1 of the original worksheet ...
|
| Pivot Table Display Question | 11 Jan 2007 07:50 GMT | 3 |
Please excuse me if this is a very simple question, however I can't seem to figure it out: I have a pivot table whose data looks like the following RELEASE # JURISDICTION REVENUE
|
| How to create a TXF file in Excel or Export XLS to Money? | 11 Jan 2007 07:48 GMT | 1 |
Yes, tax time again. Turbo Tax and other Tax software accepts .txf (tax exchange files) from MS Money. Excel does not have the option to save as .TXF files. Is there a way to convert .xlf files to .txf files or to import an Excel file into money and convert to a .txf file so ...
|
| Copy formula | 11 Jan 2007 02:47 GMT | 4 |
I need to copy a formula to the right and have the column in the formula remain constant but the row increase by one for each column to the right I go. For example if in cell A10 I enter =A1 then copy that to the cells to the right, it makes cell B10 =B1 and I need it to =A2, C10 ...
|
| MS Excel: Linking spreadsheet and Absolute and Relative Paths | 11 Jan 2007 01:33 GMT | 6 |
Our staff uses several spreadsheets, many of which are linked to SEVERAL other spreadsheets. Of course, all of these documents are stored on the network. The problem we are having is the absolute path that the link uses.
|
| Text in Pivot Tables | 10 Jan 2007 21:18 GMT | 4 |
When doing a Pivot Table is it possible to have text instead of numbers in the table? If so, how can this be done. Greg
|
| CHIINV | 10 Jan 2007 20:40 GMT | 1 |
I have some questions on CHIINV() computation on Excel. According to the help files: If degrees_freedom is not an integer, it is truncated. If degrees_freedom < 1 or degrees_freedom = 10^10, CHIINV returns the #NUM!
|
| Display number as negatiove always | 10 Jan 2007 20:28 GMT | 4 |
Easy one for you pros (I think). Is there a way to set up a cell to always display a number typed into it as a negative number? Thanks for any help.
|
| Squirrely Cursor Arrow Keys | 10 Jan 2007 20:14 GMT | 3 |
Suddenly my cursor arrow keys are behaving strangely in Excel 2003 11.8117.8107. Traditionally when I hit the down arrow key, the selected cell drops down one row, etc. Now if I hit the down arrow key, it drives the window elevator on the right down a notch -- so the selected ...
|
| separating the value | 10 Jan 2007 20:13 GMT | 1 |
In one cell I have name in this format XXX - XXX - PHOENIX, XX. My requirement is that the out should show PHOENIX. Please help. Thanks
|