| Thread | Last Post | Replies |
|
| i think i need goal seek or other type of statistic function | 08 Feb 2007 11:39 GMT | 2 |
difficult to explain without drawing a picture, but i need to figure out future "x" values with given "y" values and also with a given line. the "y" axis = 1,000,000
|
| Could anybody tell me how to add values based on dates. | 08 Feb 2007 11:00 GMT | 1 |
I want to get the sum of a particular month E.G. 1 Jan 07 to 31 Jan 07 from 6 months data?
|
| ranking | 08 Feb 2007 10:53 GMT | 6 |
I have a table which looks like this PERCENTAGE PLAYED WON LOST DRAWN TOTAL SCORE 70.0% 5 3 1 1 10 50.0% 5 2 2 1 7
|
| Wrong result on dividing 2 values | 08 Feb 2007 09:58 GMT | 1 |
On Sheet 1, I have a cell E9 with a value is calculated by linking to a value in Sheet2. The formular in cell E9, Sheet 1 is look like this =('Worksheet2'!H13*0.1). The value in Cell H13 sheet 2 is $289.79 multiply by 10%. The formular gives me a correct result in Cell E9, ...
|
| Times in Excel | 08 Feb 2007 08:44 GMT | 6 |
Hi I am trying to calculate number of hours between 2 times. I am helping someone in a hospital. If a patient checks in at 18:00pm and checks out at 03:30am - how can I calculate the number of hours they were in the hospital.
|
| Why security warning still appear after I delete all macros | 08 Feb 2007 05:51 GMT | 1 |
Hi, I keep receiving security warnings everytime I open a workbook that previously contained macros. I have deleted all macros and I can't find anymore macros left. Visual basic code also appears to be empty. Is the macro being stored at somewhere else? Is there anyway that I can ...
|
| averaging with conditions | 08 Feb 2007 05:16 GMT | 5 |
A1 Height1 Height2 Height3 Height mean B1 157.6 157.7 159 ? I need a formula that will average the two closest figures and ignore the third figure. eg Height 1 and Height 2 are closest therefore average these
|
| The '" -- " before a function | 08 Feb 2007 04:14 GMT | 4 |
What is the name of this symbol and what is it do when placed in front of a function name. ie. --isnumber........ Thanks
|
| How do i automaticaly number consecutive forms | 08 Feb 2007 03:02 GMT | 2 |
I need to generate consecutive forms and number them for future reference, to run on Excel 2000 and 2003.
|
| Help with Lookup(), VLookup | 08 Feb 2007 01:06 GMT | 6 |
I have some data in one sheet similar to this: 100.0 2.2 200.0 3.1 300.0 1.9
|
| sorting through unknown source data as it is entered | 08 Feb 2007 01:03 GMT | 1 |
If Worksheet1! column A is designated for names and column B is for #sales, but NO data has been entered in either columns yet, Can I have another worksheet (Worksheet2! column A & B) create a running list of how many sales each employee makes to date?
|
| Counting Match Fomulas? | 08 Feb 2007 00:37 GMT | 2 |
I've got a few sheets in my workbook. One sheet (titled Open Documents)I have imported from another program which tells me document numbers, titles, originator or responsible person (this column lists multiple people in one row), dates opened and closed, type of
|
| Nested IF statements | 08 Feb 2007 00:17 GMT | 4 |
I want to evaluate a cell reference to determine if the amount is <= 2400. If the amount > 2400 then multiply the amount by .25 If the amount <= 2400 then subtract 265 and multiply the difference by .25
|
| Using Formula based Cell Content Return Unique Consecutive Duplicate Values | 07 Feb 2007 23:33 GMT | 8 |
I have a Named Range called "Data" that spans 8 columns and 7 rows. A Numeric Value will appear only once in a row. Each row's Numeric Values are in ascending order. A unique consecutive duplicate MUST be in the SAME column. I would like to Return Unique Consecutive Duplicates ...
|
| The Kth element in a text list | 07 Feb 2007 22:59 GMT | 15 |
=Small(A1:A5,2) from 12 15 12
|