| Thread | Last Post | Replies |
|
| How do I plot an expression in excel? | 16 Nov 2007 14:19 GMT | 1 |
Is it possible to get excel to plot an expression (e.g. 2*C3)?
|
| create footer, sum of column values | 16 Nov 2007 13:10 GMT | 1 |
dear sir , i want to create the sum of column(cells values ) like sum( "a3:a end ") at the end of the sheet like footer and to have an perfect print out as detail as detail and totals as report footer
|
| Gridlines on partial sections of sheet | 16 Nov 2007 12:27 GMT | 2 |
How do I display gridlines in only a sub section of a sheet? The block of cells above will be all gridlines but in some rows below, I do not want all the columns to have have gridlines. Thanks.
|
| Find first digit of value | 16 Nov 2007 12:21 GMT | 3 |
I have a large vector of values with a wide dynamic range (10^-6 to 10^- 16). For a particular application, I need to retrieve only the first digits of the values, yielding an output vector that contains only the values 1 through 9. I can do this manually fairly easily by first
|
| Programming | 16 Nov 2007 11:56 GMT | 7 |
I have quite a comprenhesive database which I wrote and use in Excel2002. But now I'm looking at updating it, and I'm thinking towards moving away from Excel and making it a standalone program. My programming skills stopped sometime after QBasic in Dos, but I'm looking
|
| print half of rows on left and other half on right | 16 Nov 2007 11:20 GMT | 2 |
I've got 816 rows in thin columns. I want to print down to 408 rows and then have Row 409 appear at the top of the first page. That is, if it takes 4 pages, Page 1 is data row 1 down to 100 on the left and 409 thru 500 on the right side of page 1.
|
| technical problem of newsgroup usage | 16 Nov 2007 10:31 GMT | 2 |
For some time I can't use Notify feature of this newsgroup. When I check Notify me checkbox in my own posts, it works, but pressing Update notify button for other posts doesn't. Can anybody tell me the reason or put me in the right direction where to ask
|
| How to convert numbers to text format? | 16 Nov 2007 10:29 GMT | 2 |
if i have 1 in cell a1, i need that to be changed into One in cell B1, how is this done? regards kishore
|
| Baby stuff I know-if | 16 Nov 2007 10:27 GMT | 8 |
HI, Which formula I need to write So when the cell in A1 is >0 but <1 then give me 1; but if >1 then give me the number thanks
|
| autotab | 16 Nov 2007 10:04 GMT | 4 |
I made a "short" macro with a button that is going to enter the time of day....but would also like to "autotab to next cell" for the next time stamp. How do I fix that? See code below. Sub TimeStamp()
|
| superimposing charts | 16 Nov 2007 07:31 GMT | 1 |
How to superimpose two different chart with same X and Y axis in EXCEL? Thanks
|
| Pivot Chart Data Data range cannot be changed | 16 Nov 2007 05:54 GMT | 2 |
I have created a Pivot Chart, but I am unable to change the Data Range when I go to Select Data. (It's greyed out and unselectable.) The help tells me I should be able to do that, as follows. Furthermore it also seems to say that I only need to select the first cell when creating
|
| Copying Sheet with Pivot charts | 16 Nov 2007 05:49 GMT | 3 |
I have created a sheet with 2 pivot charts. The pivot table for each chart is also on the same sheet. I now want to copy that sheet (about 6 times), and change the Pivot Table filters slightly ie I select a different State of Australia.
|
| VLOOKUP | 16 Nov 2007 05:15 GMT | 2 |
I have a large data with two columns (Col. 1 Location, Col. 2 Code) in sheet 1. in other sheet or workbook I want that, if I enter Location in cell then the Code display in next cell using VLOOKUP or any other way.
|
| Formula & text in one cell | 16 Nov 2007 04:11 GMT | 6 |
I am trying to add a label to the numbers in one cell. I want the formula to calculate the numbers, but then I want it to say "per hour" after the numbers in the same cell. So, for example, the cell would read "$16.99 per hour" How can I do this?
|