| Thread | Last Post | Replies |
|
| Time (Hours) calculation | 16 Jun 2006 07:28 GMT | 1 |
I want to be able to place a time & date in one cell, Place a total hour figure in another cell, and a result in (Time & Date) placed into a 3rd cell. How would i do this if say:
|
| Starting another program out of Excel VB?? | 16 Jun 2006 03:52 GMT | 1 |
How do/can I start another program, like WORD or NOTEPAD, from an EXCEL VB routine? I tried doing it with the Marco definition button, but that doesn't collect things that happen outside EXCEL.
|
| Average of lowest 5 of 20 values? | 16 Jun 2006 03:49 GMT | 5 |
The following are what golf handicappers call differential values. I've listed 25 of them. To compute my golf score handicap I need to take the average of the lowest 5 of the last 20 of these values, and multiply that by 0.96.
|
| look up a value in one column to another colum | 16 Jun 2006 03:30 GMT | 7 |
I am trying to check it a item is new. Comparing two columns (900-1500 records) I using IF(ISNA(LOOKUP(A2,G$2:g$1474)),"","Match") But match is not being returned for any records sample of data
|
| Use of IF function | 16 Jun 2006 01:10 GMT | 4 |
I want to use the IF function more than 7 times. Can anybody tell me how to do it ?
|
| Filter formula | 15 Jun 2006 23:59 GMT | 4 |
I have a autofiltered table with many columns. I would like to display which columns are filtered (and the criteria used) in cell A2. Is there a formula that returnes the filters used? Regards
|
| #N/A in mode worksheet function | 15 Jun 2006 23:55 GMT | 3 |
Can anyone telle me when #N/A occurs as the answer to an worksheet function? If I try to find the mode of the list of codes below, I get #N/A 7372
|
| Adding category totals | 15 Jun 2006 23:47 GMT | 3 |
Hello Thanks for reading. I have 2 columns one has the Category and the other has the Time spent Example: A1=15 B1=Email
|
| Excel: want neg numbers to show red/pos green via if-then formula | 15 Jun 2006 23:24 GMT | 3 |
I am trying to have the negative numbers in a cell turn red and positive ones turn green as the values change. I would like a formula that says "If number is negative, display text red" and "If positive then display green." I know you can make negative numbers red in options, ...
|
| Intersection of row and column based on input | 15 Jun 2006 23:21 GMT | 5 |
I have a problem. I am trying to get a function to return a value from a table on a different worksheet. Here is a small example of my spreadsheet: Table with Data Keyed in called Input Sheet: May-06 Jun-06 Jul-06 Aug-06
|
| Excel should let me set print gridlines as a default | 15 Jun 2006 23:17 GMT | 1 |
I want gridlines to print on nearly every Excel worksheet so want to make it a default option. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the
|
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | 15 Jun 2006 22:29 GMT | 3 |
hi there i am really in a delima here i want to copy cell C1:C10 (which is a formula and displayed vertically) into SHEET 2 in a horizontal format, so at the end if i make any changes in sheet 1(vertical) it should be displayed automatically in sheet 2 (horizontal) can anyone ...
|
| Have a worksheet = cell value (Time!B2 vs C2!B2 when C2 = Time)? | 15 Jun 2006 22:22 GMT | 4 |
How can I set the worksheet I am referencing in a formula to be the text in a cell? I have many worksheets with the same formatted data. If I am able to do this I can pull the data I need from each worksheet without retyping my formulas by just referencing a row of worksheet ...
|
| How to spread 15,000 into 12 months at 10% ? | 15 Jun 2006 22:12 GMT | 1 |
I want to know how to plan payments with monthly interes rates. If I borrow 15,000USD at 10% interest annual, what is the formula on a spread sheet? I have Office 2003 Pls advise, thx
|
| how to calculate the area under the curve in the excel? | 15 Jun 2006 22:02 GMT | 2 |
how to calculate the area under the curve in the excel?
|