| Thread | Last Post | Replies |
|
| Automated Macros? | 01 Apr 2008 00:36 GMT | 1 |
The problem where we are having problems is this: The design team creates a product. Each product has a list of parts : 2 of this 3 of that. No product is the same. The list is then converted to a .csv file, which would then be needed to be converted into labels for each individual ...
|
| Multiplying one known number with fluctuating numbers in cells | 31 Mar 2008 22:55 GMT | 5 |
This should be really easy, but I am very elementary with formulas. I can add and subtract two numbers basically. Okay, I made a spreadsheet to figure taxes. I need to figure the sales tax on my gasoline receipts. So I need to multiply .384 by different numbers
|
| I need elegance..... | 31 Mar 2008 19:05 GMT | 12 |
I'm stumped and asking for elegance here.... I have a table that doesn't scale in a linear fashion (it is for use with computing the langolier pool water index) when I check the water I get a test result to compare to my table,
|
| if function | 31 Mar 2008 17:51 GMT | 5 |
Hi doing my cert 2 and i am stuck on 1 formula i need to work out the total cost of something where the first 1000 are $0.50 and anything over 1000 is $0.40 using if function. It all seemed so straught forward till i got to this.
|
| Remove Space in Cells | 31 Mar 2008 17:36 GMT | 8 |
Greetings, again. I hope I'm not getting too annoying by posting so often, but I can't solve this problem on my own. I am using MS Excel 2007. I have a column with cells full of text, the word count of which is of various length. The cells are aligned (horizontal) left (indent) ...
|
| if...and | 31 Mar 2008 16:27 GMT | 6 |
All, How do i say, in a IF formula, if C8 is greater than 0 and C7 is equal to zero, sum C9-E5 and then add on C10, or else say "see Kirstie"
|
| worksheet reference displays 0 on blank cell | 31 Mar 2008 15:54 GMT | 2 |
We are working on a spreadsheet that has two worksheets. The second worksheet has references to cells in the first worksheet. These references are just supposed to re-display text that are on the first spreadsheet.
|
| Chronological Date Orders | 31 Mar 2008 15:52 GMT | 2 |
I have a worksheet column (L6:L34) into which users are asked to enter dates that payments are made. The columns are formatted as 'Date' and Data Validation is set to ensure a date is entered. A blank entry is allowed.
|
| Sumproduct Question #1 | 31 Mar 2008 15:45 GMT | 5 |
I have been doing a lot of reading on this function and can usually get it to work to do the job - not overly complex. One thing that is still not understood (and not the only thing) is what is the difference between using * or , to separate the arrays in the argument?
|
| hlookup or other method | 31 Mar 2008 15:42 GMT | 3 |
I have a spread sheet of 100 rows & 60 columns Bottom row is years 2008 thru 2068 -- Range A1:BH100 Columns have numbers scattered randomly. Most numbers are 0 Some rows have only one column with a number, others have several columns
|
| Conditional formatting - how to populate through 150.000 rows? | 31 Mar 2008 14:30 GMT | 6 |
the title says it all; say I'm using conditional formatting formula in the R1 and I want to populate it throughout 150.000 rows (Excel 2007, of course); is there an easy way to do this (I mean, something instead of having to drag 'the corner' all the way down ...) ? Some kind of ...
|
| Excel 2 word | 31 Mar 2008 13:45 GMT | 1 |
is it possible to automatically link excel and word (i currently use excel 2003) so that when i input a figure in to excel it automatically replicates itself in word?
|
| Excel 2 Word 2 OE 2 Mail Merge | 31 Mar 2008 13:26 GMT | 2 |
Re: Excel 2 Word 2 OE 2 Mail Merge I am not good at clearly explaining myself or anyone else's self. I use Office 2007 Proff but not as a pro ( NOVICE ). I have a list of names with address, phone, etc. in an EXCEL file. I would like to add all that
|
| Long file load time @ 100% CPU - Excel 2003 | 31 Mar 2008 11:38 GMT | 2 |
I've got an .xls file (97 - 03) that has been worked on for a number of days now, suddenly it now takes minutes to load (it consists of two active sheets, total size is 2.55 Mb). It saves quickly enough, however even if I save it using another name, it
|
| Add year date to x axis - Excel 2003 stacked column chart | 31 Mar 2008 00:45 GMT | 1 |
I am trying to add 2002 -2005 dates to the horizontal x axis of a Stacked Column Chart in Excel. It either comes out as 1 2 3 4 or 1900 (x four times). Can anyone help please?
|