| Thread | Last Post | Replies |
|
| Combo Box Values not Numbers | 17 Aug 2005 13:41 GMT | 8 |
How do I get a combo box to return values not numbers. My combo box displays January - February, but my linked cell only displays 1-12. How do i get what is actually in the combo box to appear in the linked cell.
|
| Can I make the number in one cell automatically appear elsewhere? | 17 Aug 2005 13:12 GMT | 2 |
If I enter a number in one cell in my workbook, I would like it to automatically appear in several other cells. The 'destination' or 'target' cells cannot have any formula in them. I need to be able to enter any number in the original cell and can use
|
| Month Counter | 17 Aug 2005 13:11 GMT | 2 |
Does anyone know how to count months between two dates. I want to be able to go beyond 12 months. 01/01/2005 - 01/01/2004 = 13 months. Month(Date2)- Month(Date1) = will only give me answers from 1 to 12 I was originally using the formula :
|
| 'vlookup' and/or 'if' help! | 17 Aug 2005 12:53 GMT | 5 |
Hello...i'm in charge of conducting a physical training test and have a table already created with the parameters of the test. Here is a partial table: % 1.5 mile 300m Bench sit-ups push vertical
|
| Conditional functions | 17 Aug 2005 12:48 GMT | 1 |
Can someone please help, I want to achieve the following. 2 worksheets, results and data Data sheet has the following colums Size Wegcost Cempcost
|
| MsgBox with condition and showing details | 17 Aug 2005 12:38 GMT | 2 |
I have two columns, one called NAME and the other BIRTHDAY. I want a MsgBox that appear when a cell in BIRTHDAY take place during the current month, and display the name of the person.Something like "JASON, PETER and JOHN HAVE BIRTHDAY THIS MONTH" . Moreover, I want the MsgBox to ...
|
| excel, how do I get sumif with two criterias? | 17 Aug 2005 10:20 GMT | 1 |
I've got a table with many columns and I want to add the last left column but using two criterias for two different columns.
|
| the option to send an exle file as an attachment is not there | 17 Aug 2005 10:20 GMT | 1 |
I do not have the option to send an opened XLS sheet as an attachment to be sent thru Outlook express ? Regards Sandeep
|
| time conversion frustration | 17 Aug 2005 10:09 GMT | 1 |
I have a cell giving total minutes (using SUMIF) and need to convert the total into hours and minutes (real time, not decimal) for costings. =SUMIF(B4:B200,B8,K4:K200) the total for the cell (eg. S11) needs to be shown in hours and
|
| Sumproduct Problem | 17 Aug 2005 09:39 GMT | 4 |
I have a spreadsheet that documents details about files contained within a document repository. There is a data sheet containing an audit history of all actions that I run formulas against. I use the following formula to successfully return the date when the last
|
| Future Value | 17 Aug 2005 09:24 GMT | 2 |
Can you please help me to apply a formula in excel where I can find a future value of an investment "X" years from today, according to the following example: Present Value: $4,000.00
|
| conditional sum question | 17 Aug 2005 07:28 GMT | 6 |
I want to add a range of values, but they are formatted differently: some of them are formatted with the dollar currency, others with the euro currency. Excel treats them equally, as numbers, but I need to make different sums automatically - I want to add only dollars or only
|
| data analysis on fields with words not numbers | 17 Aug 2005 05:49 GMT | 3 |
How can I get the total number and percentage of for each different word in a column which has several word descriptions? What function do I use?
|
| if functions | 17 Aug 2005 05:41 GMT | 2 |
I have the following problem: In sheet 1 I have : Column A > party codes (Customers) Coloumn B > Bill number
|
| select a string of characters | 17 Aug 2005 04:25 GMT | 7 |
I have some large cells with various data, some (not all) contain a unique string of charaters which I would like to extract to another cell. The string of characters is two alphanumerical then six numerical then one alphanumerical. For those in the UK, like National Insurance ...
|