| Thread | Last Post | Replies |
|
| STDEVPA question | 12 Dec 2005 04:55 GMT | 2 |
I need to run a standard deviation STDEVPA on rows of numbers from a table of data. I need to lookup a reference and then return a row of numbers right of that reference to run the STDEVPA on. VLOOKUP doesn't do it since it can only return one cell value. Does anyone have an idea ...
|
| match and if then | 12 Dec 2005 04:44 GMT | 1 |
if some one has a little time would you please email me, and see if you can help
 Signature Teerings3
|
| Find percentage ??? | 12 Dec 2005 04:40 GMT | 3 |
How do I find percentage of a number... say.. A1 = 100 A2= 60% of A1 (100)
|
| Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help! | 12 Dec 2005 04:31 GMT | 2 |
I have a spread sheet that has the following cells: A1 is a material dd list of slings (rope, wire rope, synthetic web) B2 is a material type - if rope is selected in A1 then in B2 you only get types of rope, if wire rope is selected, you only get types of wire rope, etc
|
| How do I change my typing from horizontal to vertical | 12 Dec 2005 03:18 GMT | 2 |
I am making a chart and I do not know how to make some of my boxes go from horizontal typing to vertical.
|
| Copying Formulas | 12 Dec 2005 02:37 GMT | 7 |
How do I copy a formula from a group of cells to another group of cells without excel editing the formula? For example, I want the exact same formula from one group copied to another group - as is - without any changes to it at all. For example, I am using
|
| Dynamically-linked formula, cell reference in the string | 12 Dec 2005 01:36 GMT | 4 |
I have a series of formula which use the same condition. Eg: C1 contains the string of the testing condition, [eg IF(AND($D1=$E1, $F1=0), "", ]
|
| I need to consolidate data from 3 different worksheets? | 12 Dec 2005 01:04 GMT | 1 |
I need to consolidate data from 3 worksheets, each having 4 rows of reference information, that will calcuate the average of all 3 worksheets onto a 4th worksheet. How do I do this? I have to use Excel spreadsheets.
|
| Today's Due Date in Colour | 11 Dec 2005 22:20 GMT | 2 |
Please help. I have a column called "Due Date" I will like every morning, to have all the dates that are due the current day (()Today) to be highlited in red. Can this be done, if so how?
|
| YIKES! All Validation functionality DISAPPEARED! | 11 Dec 2005 22:11 GMT | 3 |
Help Please! I'm not sure how this happened! I had various cells in my worksheet with validation functions/drop down menus. The reference lists are still there.. but the arrows and menus within the cells disappeared! Not only that, but I
|
| Yes, No, N/A in formula | 11 Dec 2005 22:10 GMT | 2 |
Here is a formula that was provided to me. It works great. However, after reconciling my data I found that some cells in column K will need to have a N/A vice a number. Therefore, the below formula (in cloumn C) is reading the N/A and providing a false "No". Actually if there ...
|
| Conditional subtotals | 11 Dec 2005 21:10 GMT | 10 |
I have a subtotal question Let's say I have this set of data A..................B..........C date_______amt_ sub
|
| add data to combo box in excel then invoke macro | 11 Dec 2005 20:50 GMT | 1 |
I want to either add a combo box or using data validation creat a list of peolpes names. I will create a worksheet with each persons name and use the result of the combo box or drop down list t navigate to the corresponding worksheet.
|
| #VALUE! | 11 Dec 2005 19:39 GMT | 4 |
Hello from Steved Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510. =(D3+12)*100 Thankyou
|
| Macro required | 11 Dec 2005 19:36 GMT | 3 |
I would sure like to have a macro that will do the following: 1. Select B1 2. Run down the B col until it finds a blank 3. Then paste in that blank line (starting a col B )what has been placed in
|