| Thread | Last Post | Replies |
|
| Unable to print comments | 18 Jan 2008 20:04 GMT | 1 |
I have tried Page Setup; Comments "as displayed on sheet" and still the comments will not print. I also have made sure the "comment indicator" was selected in my options. Can anybody help?
|
| Conditional Sum Across Multiple Worksheets | 18 Jan 2008 19:33 GMT | 4 |
I am trying to conditionally sum values across multiple worksheets and cannot seem to get it to work. Basically I have 130 different worksheets each representing a day. Each day has multiple job codes (only 8 different codes are used throughout though) and I want to sum the ...
|
| Not sure how to explain.... | 18 Jan 2008 19:14 GMT | 12 |
Ok.. I don't know how to explain what I'm asking, so I'll just give an example. I have to enter in A TON of data containing both letters and numbers. All of them start with 350TT.... and then it end up looking something like this: 350TT-D-1-1/2"-2"
|
| excel and word | 18 Jan 2008 19:06 GMT | 1 |
I have a spreadsheet containing information on about 600 employees (name, idnumber, department, position... etc) I also have a word document, a survey form which i need those employees to fill out. I would like to personalize each survey with information from the spreadsheet. Is ...
|
| Nested functions | 18 Jan 2008 19:04 GMT | 4 |
I am trying to set up a formula, such as below but can't get past the first "if function. Can someone help So far this is what I have =IF(A2="BIRS",E2>0,0)
|
| Multiple conditions and IF Statements | 18 Jan 2008 18:54 GMT | 4 |
Hello--I am trying to write an IF statement with more than 2 conditions. Ultimately, I would like to have a formula that calculates the following: IF #1 -- #2 is > 10, return "Yellow," Otherwise, return "Green." AND/
|
| Global percentage decimal places default formatting | 18 Jan 2008 18:54 GMT | 2 |
I need to display a lot of percentages in my Excel sheets and charts. Changing the display format to percentages requires you to specify how many decimal places, or accept the default of 2. Changing the default is very time consuming and I wonder if it is possible to change ...
|
| Negative Values in Excel | 18 Jan 2008 18:47 GMT | 5 |
Is it possible to have a series of cells automatically add the negative sign in front of an inputed number?
|
| Convert Excel database to dBASE database? | 18 Jan 2008 18:25 GMT | 1 |
Trying to use Excel database to print full page of Avery labels with varying data on each label in the page. MS Office sofware on a Dell Optiflex 320. Trying to use Avery DesignPro 5.4 as a desing tool to offer set help to do this.
|
| find the difference between start time and end time when spanning. | 18 Jan 2008 18:02 GMT | 8 |
I'm trying to find the difference between start time and end time when the total time will exceed a 24 hour period. 10:00 PM Friday 3:00 AM Sun
|
| Can I link a comment to a chart ? | 18 Jan 2008 17:46 GMT | 1 |
I have data in a worksheet and only the occassional cell has a comment inserted into it. Is there a way to have this comment linked to the chart created from the data in the worksheet? What I would like to be able to do is when I mouse over the particular data point in the ...
|
| Color Help Please | 18 Jan 2008 17:40 GMT | 6 |
i am running excel 2000 (yah its a little old but gets the job done) ok here is my question. lets say i have a whole list of numbers in a unknown amout of cells in a column. for example: 357,901 357,902 and 357,903. how would i make the highest number (357,903) turn red, Also how ...
|
| Formulas not updating | 18 Jan 2008 17:39 GMT | 5 |
Is anyone else having a problem with formulas not updating properly in Excel 2003? I have two workbooks. The first one has 21 worksheets and the last three are formula worksheets
|
| Cell Location in Array | 18 Jan 2008 17:36 GMT | 2 |
I have a table on Spreadsheet 'A' - O1:S1000. Is there some way to look up a value from Spreadsheet 'B' in the table on 'A', and return either the row in the table where the value was found, or the column where it was found, or the cell address, or all of the above?
|
| Addition & multiplication formula | 18 Jan 2008 17:32 GMT | 7 |
I have added a column of numbers using the following formula so the total cell will be zero if there is nothing in the column: =IF(count(F8:F26),SUM(F8:F26),"" Now I want to multiply that total by cell F27 and put the total in cell F28.
|