| Thread | Last Post | Replies |
|
| vertical lines between credits and debits | 28 Mar 2006 05:23 GMT | 1 |
Basic book-keeping. How do I get 2 vertical lines between credits and debits. I would have thought that would be automatic!
|
| Rounding to a month | 28 Mar 2006 04:37 GMT | 3 |
Hello, I have a list of 1000 items with dates over the last two years. Many duplicates, etc. I need a formula that transforms the dates to a single date with the month and year. To be more clear ... I am looking for the following ...
|
| Easiest way to create a link? | 28 Mar 2006 00:48 GMT | 3 |
I'm just creating a simple link by typing the following: ='Sub Contracting'!F10 in the obvious format of ='worksheetName'!cell
|
| Hiding a total until all values are filled | 28 Mar 2006 00:15 GMT | 5 |
I want to forcast certain dates based on a persons age. For example, my daughter was born on 11-5-96. I want to forcast her 8th, 12th, and 18th birthday. I am wanting to do this for a hundred or so youth at our church. So, I put in the following =DATE(YEAR(B1)+8,MONTH(B1) ...
|
| error analysis | 27 Mar 2006 23:06 GMT | 2 |
I have a graph of Force(mN) vs Distance(m). The error in the force is 0.0001g and the error in the distance is 0.0254mm. I have 10 points on the graph. Excel gives R^2 = 0.90. My gradient is 1.045. What is it's error? Can someone help?
|
| Convert seconds to minutes | 27 Mar 2006 21:42 GMT | 5 |
I have a excel sheet in which all the values in a column are in seconds. Is there a way in which i can convert all the values in that particular column into minutes. Regards
|
| Horizontal Scrollbar | 27 Mar 2006 18:42 GMT | 2 |
Is there any way where I can use Mouse "roller" the center rollball to scroll the Horizontal Scrollbar instead of using mouse to click and drag it thanks
|
| Same formula in every cell of a column/ storage space reductions | 27 Mar 2006 18:38 GMT | 2 |
I have to do some easy calculations with some data from a sales data base. It is about 55 thousand lines needing 15 MB of storage space. The data has always the same structure for every product (all stored in one line).
|
| Temple Task Pane - Excel 2003 | 27 Mar 2006 18:26 GMT | 2 |
Whenever I click on the dropdown arrow of the Getting Started Task Pane I can't figure out how to activate the Template Help Task Pane. So how do you activate and what does it do?
|
| Comparing data in columns | 27 Mar 2006 18:17 GMT | 1 |
I am trying to compare the following data: code amount code amount 176824 17463 176824 17463 92674 84116.82 92674 84116.82
|
| template or formula for start time -finish time -total hours ple | 27 Mar 2006 18:06 GMT | 1 |
please could I have a formula or function to enter start time-end time and show total hours/mins for excel
|
| trying to add a collum to an existing page. | 27 Mar 2006 17:46 GMT | 2 |
I can't seam to figure out how to make the lines to separate a new collum. Can anyone help me?
|
| strange thing when cutting and pasting in excel | 27 Mar 2006 17:08 GMT | 3 |
I am dealing with a block of data that is 8X12. The data is generated on a networked piece of lab equipment and I save the results into my folder. When I get back to my workstation to retrieve the data, I open the folder and then perform "move or copy" to copy this opened ...
|
| subtract 3 numbers and 2 cells | 27 Mar 2006 16:53 GMT | 1 |
How would I do this, I=100-E4-G4? I have E4 as 97 and G4 as 0 so the answer should be I = 3. Please help.
|
| Alternating gray rows on my Excel reports | 27 Mar 2006 16:41 GMT | 10 |
I have a report that is nearly 1000 rows long and to make it easier t read when I print it, I would like to have every other row, starting a row 1, to have a gray background. Is there a way to do this easier than having to select each ro
|