| Thread | Last Post | Replies |
|
| Conditional Formatting across many cells with a mobile comparison | 27 Sep 2006 06:37 GMT | 2 |
My description was probably more confusion than helpful but here we go... C4 has a hard coded value in it. The range C8:V8 has values created due to a formula (say something like D8 has =SUM(C8,D7) and E8 has =SUM(D8,E7).
|
| Print Page Numbers | 27 Sep 2006 06:15 GMT | 2 |
Is it possible to create a formula that returns the page number relating to a particular cell? For example, I have a print range set up that has multiple pages and I would like to determine what page number a particlar cell, say "F123", will appear
|
| Formatting a Cell as "Time" | 27 Sep 2006 06:15 GMT | 2 |
Hi... I'd like to format a cell as "Time". I want to use the 24 hour Timing system, but When I enter the time: 24:00, I don't want it to apear like this: 0:00. Is there any possible way to do this.
|
| Would I use an "If and" statement? | 27 Sep 2006 04:36 GMT | 2 |
I have a table as shown. Column A Column B Y ???? Y
|
| Getting the sum of the same cell in defferent exel sheets. | 27 Sep 2006 03:54 GMT | 2 |
I am working on a big excel sheet, and I am kinda new at it. How can I get a sum of the values on 45 different excel sheets? I can only get the sum of about 15 sheets for so before it says that my formulat is too long. Here is an example of the formula: =SUM('Service Invoice ...
|
| Pivot Table - Drill down to source and update | 27 Sep 2006 03:50 GMT | 1 |
Is there a way to drill down on a cell of a pivot table and update or change the underlying source data from the pivot report? I'm afraid that the users will have too much trouble understanding the data in a matrix or table format. The Pivot Table report is being used as a budget ...
|
| Data Entry problem | 27 Sep 2006 03:35 GMT | 2 |
When I try to type in "1:500" without any formula in it plain text excel return a value of "0.388888889". Why is that and what is the colon mean. I try to work it out i got no clue how excel got that value. Thanks in advance
|
| Data entry | 27 Sep 2006 02:47 GMT | 3 |
When my boss tries to type a quotation mark, it does not appear nor does the cursor advance until you press the spacebar. How can I correct this?
|
| Under Page Setup the page option of Ledger - for Office XP | 27 Sep 2006 02:46 GMT | 2 |
Have someone using Excel 2002, needs to print an Excel file on Ledger size paper. However, they do not have this choice under page setup. Reinstalled Office using complete install - did not add this feature. Installed SP3 for Office XP, and all the updates - still no Ledger ...
|
| excel generated polynomial equation is wrong | 27 Sep 2006 02:45 GMT | 9 |
fitting a trendline to data and the polynomial equation it spits out is obviously wrong. Any ideas? thanks
|
| How can I do a mail merge w/ Excel contacts into a Word document? | 27 Sep 2006 02:45 GMT | 1 |
I have 200 contacts in an excel spreadsheet. I want to type a letter in Word so that each letter will be written to a different contact. Thanks in advance for any suggestions.
|
| where can i find the auto fill options? | 27 Sep 2006 02:43 GMT | 1 |
plz tell me where can i find the atuo fill options and also where is the toggle total row thank you
|
| Cannot remove read only attribute | 27 Sep 2006 00:37 GMT | 2 |
A frequently used .xls file suddenly could not be modified because it was labelled 'read-only'. The read only attribute can be removed but when the file is closed and re-opened the read only has returned. Data cannot be saved to the original file on closing. Can anyone please ...
|
| Formula to count cells that contain a number & are not shaded | 26 Sep 2006 23:52 GMT | 2 |
I am trying to get Excel to count up blank (or non-shaded) cells, as well as cells that contain a "1" in it. Can someone please suggest a formula to do that? I really need it & an excel "guru" told me it could be done, but he didn't remember how. Any help would be greatly ...
|
| COPY | 26 Sep 2006 23:38 GMT | 1 |
I would like extract the entire row of information from the received excel spreadsheet into the non-compliance excel spreadsheet that meets the criteria of "OLD", "0" "XL", "XC", "XR" or "VAC". There are five columns that could contain this information. Please note that it is ...
|