| Thread | Last Post | Replies |
|
| Average number of months | 27 May 2008 00:26 GMT | 1 |
I have a column (Excel 2003) that contains several dates in mm/dd/yyyy format and I would like to be able to obtain the average number of MONTHS in the group of dates. I could, if it made it easier, add seperate columns for - month - day - year
|
| copy and autoadjust formula | 26 May 2008 22:58 GMT | 1 |
I have a workbook with many consecutive sheets (one for each day)In 3 different cells (on the same location in every sheet) there is a formula, which comes from the previous sheet. Eg: C3Tuesday='Monday!F3. How can I copy these formulas so that they autoadjust from sheet to
|
| Sum and multiply | 26 May 2008 22:44 GMT | 8 |
I have in row A for E.G. amounts, lets say: A 3 6 4 B 2.00 3.00 2.50 Is there an easier way to calculate all together. The long way is
|
| displaying 1st, 2nd, and 3rd in one cell | 26 May 2008 22:22 GMT | 3 |
I've used the 'large' function to determine the first three largest values in a set of numbers. Now I would like to display those values in one cell. For example, I would like to display the top three values as 80, 73, 62. Any suggestions are appreciated.
|
| Return on a bond | 26 May 2008 22:13 GMT | 1 |
Does somebody have a formula to calculate the exact real return on a bond. With time to go, not just in years, but with exact dates, and including purchasing-costs,... Thanks in advance.
|
| Greater than # but less than # | 26 May 2008 20:47 GMT | 3 |
I want to do a count of how many #'s are between this %range (ex <=80%, <+99) I am not having any luck doing this. Any help would be great! thanks
|
| time calculation for airline standby | 26 May 2008 19:34 GMT | 5 |
could anyone help regarding a calculation re the above. what i am try to do is this: i start a standby at 6:00 and i finish it at 18:00 = 12 hrs but i am called to work at 15:00, so i have completed 8hrs stby. now i can
|
| Automatic refresh of external data | 26 May 2008 18:41 GMT | 1 |
I've made several excel templates with information directly linked to an access database query. When I open the excel template, I need to confirm "Enable Automatic Refresh" (unfortunately each independent template)
|
| Excel 2007 Natural language formula | 26 May 2008 17:26 GMT | 2 |
I am teacher Excel 2007, and I did not find how to use Natural Language in formulas. If somebody know, please, let me know. Edna
|
| How to add an inverted comma in a cell? | 26 May 2008 17:26 GMT | 2 |
I am trying to type 'Xpress' into a cell. the first inverted comma keeps disppearing. How do I solve this? Thanks!
|
| Vlookup selecting next highest value instead of equal or nearest l | 26 May 2008 17:11 GMT | 3 |
Is there any way we can make Vlookup select the next value that is highest or equal to in a cell instead of the nearest lower value
 Signature Jack
|
| Writing a formula which dynamically generates results | 26 May 2008 16:12 GMT | 5 |
Can I write a dynamic formula based on the different kind of data present in a particular column and which generates results dynamically depending on the data being added? Eg;
|
| How do I link cells from one excel worksheet to another? | 26 May 2008 15:36 GMT | 14 |
I want to link the totals of certain columns of several worksheets to a summary worksheet in the same workbook. I keep seperate worksheets of the circulation stats of my library branches, and I want the totals of my columns to automatically show up on the cumulative worksheet as ...
|
| Goal Seek with Complex Numbers | 26 May 2008 15:20 GMT | 2 |
Hello; I'm trying to understand how complex numbers are handled/processed in Excel. As related to my application, an interesting exercise would be to use Goal Seek w/s command to find the roots of the equation:
|
| pivot table | 26 May 2008 15:19 GMT | 1 |
How to use two or three sheets in a single pivot table. I have the data in multiple sheets and I require a single pivot with all the sheets. Regards,
|