| Thread | Last Post | Replies |
|
| time stamp | 21 Jul 2007 17:46 GMT | 3 |
I have done many time stamp formulas before, but am needing something a little different.... In column J, I need a formula that would give me date stamp whenver the adjacent cell in column I has the word "closed"
|
| Excel | 21 Jul 2007 14:22 GMT | 6 |
I do not have excel on my computer and need to download it for work related worksheets, where do I get it and how? I'm computer illiterit to a degree. HELP! I downloaded a viewer but it won't let me edit and I have to edit. thanks
|
| How do I add additional lines to the work sheet. | 21 Jul 2007 13:34 GMT | 1 |
Just a beginner here. I want to make the page longer with more lines and to include all formulas. Thanks
|
| format a single gridline | 21 Jul 2007 10:39 GMT | 5 |
Is there any way to format a single gridline differently from the other gridlines? There is one i would in particular like to call attention to, by making it thicker and a different color from the others. While i could just draw a line over the gridline, then that line would need ...
|
| [2007] Multi-tab printing printer tray issues | 21 Jul 2007 05:30 GMT | 1 |
I have an issue with printing selected sheets in a workbook. If a specify a paper source like tray 1 at the printer settings dialog the first selected sheet is printed to that tray, all other sheets are printed to the default paper source tray
|
| Beta testing an Excel 2007 certification test | 21 Jul 2007 01:16 GMT | 1 |
In case anyone is interested, there is a free Beta test of an MS Excel 2007 Certification test available at Brainbench.com. Here is the link to find the test: http://www.brainbench.com/xml/bb/common/testcenter/betatests.xml
|
| NUMBER LISTS | 20 Jul 2007 22:52 GMT | 5 |
I am trying to enter several hundred numbers in one colum. But would like to expel some of the time it will take to do so.. Is thier a quick way to do this...
|
| Rearranging cronological data. | 20 Jul 2007 22:02 GMT | 1 |
I have a set of 25,000 row wind data that I just want to flip so the last entry is first and the first is last. I have some crazy dates that don't match up in the data so I would like to be able to keep the order of everything now without sorting it by date. Im using 07.
|
| Modifying cell entries when changing format | 20 Jul 2007 21:44 GMT | 1 |
I'm trying to alter a column of the format "1/12/2007 9:07:00 AM" to format "1/12/2007" - that is, so that only the date shows up. When I do this, I also would like to get the data to take on this actual form (rather than just showing up this way in the cell, but remaining in ...
|
| New to formulas | 20 Jul 2007 20:48 GMT | 6 |
I need help with formulas, or a math function. Bacically what I need to do is have Cell A2 subtract Cell A1 and be outputted to Cell B2. I have no idea how to start this.
|
| Solver Reference to Add-in | 20 Jul 2007 18:00 GMT | 2 |
I have an add-in that contains a time series forecasting routine in VBA that requires the use of the Solver add-in. I want to use VBA to establish a reference to the Solver add-in for the forecasting add-in. I have attempted the following with limited success. Any suggestions ...
|
| Convert day, month, year, and time to just year | 20 Jul 2007 17:26 GMT | 6 |
Hello, what formula can I use to convert day, month, year, and time values to just a year For example, what formula can I use to convert 4/16/2002 12:59pm to simply 2002 or 1/1/2002.
|
| SeriesCollection object in Excel 2007 and 2003 | 20 Jul 2007 16:58 GMT | 1 |
I created a program that in Excel 2007 that assigns an array to a new series SeriesCollection.XValues and SeriesCollection.Values. It then shows up on the chart. In Excel 2003, there are apparently limits on how long the series
|
| Standard Diviation question | 20 Jul 2007 16:10 GMT | 2 |
I am new at excel and would like some information. I am trying to get a standard deviation for an investment portfolio. I have the std diav. for each investment but want to get the average for the whole port. I also have the % and amount of each investment. I understand that I ...
|
| Another Formulae Baffle | 20 Jul 2007 15:12 GMT | 2 |
I am trying to create a query? that will return a value, depending on the input value tothat cell. Tried using "if" but can only nest so many. I want a,b,d,e,h,l,s,t,x,z (if inputted for a days work) to return (hours worked) 8,4,9,6,1,8,8,8,0.25,0.50...
|