| Thread | Last Post | Replies |
|
| V-Lookuo | 15 Aug 2005 18:40 GMT | 2 |
I have a V-Lookup that contains email addresses. But when it transfers over to the other sheet, the link does not work. Is that possible to make happen?
|
| Count values in a cell | 15 Aug 2005 18:03 GMT | 2 |
I need a formula to do the following. I have a list: A B
|
| Delete text while numbers remain intact | 15 Aug 2005 17:32 GMT | 2 |
I need to find a quick way to delete or move all letter data from a range of cells while leaving the number data intact. I need to be able to sort my spreadsheet by the numbers in each cell, not by the letters. I could go through each cell and delete the letters manually, but ...
|
| NUF schedule | 15 Aug 2005 17:04 GMT | 1 |
I would like to improve the schedule attached. http://cjoint.com/?ipkzvZlI8y It is the calculation of the non utilisation fee (CCNU) on a revolving loan (C)
|
| Question about {} | 15 Aug 2005 16:59 GMT | 2 |
Dear Sirs I saw some functions starting with{ and ending with } What is used for? Can you give me some hints for using that things?
|
| counting in pivot table | 15 Aug 2005 16:58 GMT | 14 |
I have the data source like below: product customer quantity 1 A 1000 2 A 1000
|
| Macro to copy range of formulas to equal data lines | 15 Aug 2005 16:38 GMT | 2 |
I would like to have a macro to copy a range of formulas in row 2 down for all lines of input in an adjacent range. For example: Input Formula Row 2 Cell X2 Cell Y2
|
| PorductLog | 15 Aug 2005 14:55 GMT | 2 |
How do I can typing this formula on excel? http://functions.wolfram.com/ElementaryFunctions/ProductLog2/06/01/ Does'nt matter wha --
|
| AND function in Excel | 15 Aug 2005 14:47 GMT | 4 |
Can someone help me with a logic test using the AND function. IF(A2=A3,A10 AND D2=D3,C5) The above is what I am trying to achieve, can someone show me how to do it correctly.
|
| How to do matrix operation with complex number elements in Excel | 15 Aug 2005 14:26 GMT | 1 |
Would like to use Analysis tool pack function , Matrix multiplication with elements as complex numbers.
|
| VLookup Problems | 15 Aug 2005 13:54 GMT | 2 |
I'm sure I've done this before but I can't remember how. I have a list with times by 15 minute intervals, I want to populat this with call volumes from another list, however it does not retur the intervals with nil value. So for example, I have not return fo
|
| excel date problem | 15 Aug 2005 13:26 GMT | 2 |
actually what i need is,in one excel cell i will be entering 15/8/05 and the next cell i want to get the value as 30/8/06 ,that means next year same month with end of month date
|
| Can wildcards be used in the Logic Test of an Excel "IF" function? | 15 Aug 2005 13:25 GMT | 3 |
Currently, I'm using seven nested "IF" functions to return one of three account numbers. Is it possible to use a wildcard in the Logic Test to decrease the formula to three nested "IF" functions? If so, how? If not, any suggestions?
|
| HD I build funct @if cell=AorBorC then ...else if cell=DorE then | 15 Aug 2005 13:16 GMT | 8 |
Does anyone know how to build a formula as follows if(a4='apple' or 'pear' or 'plum', then 'fruit' else if(a4='carrot' or 'bean', then 'veg' else if(a4='bun' or 'cake' or 'donut' then 'pastry' else a4)))
|
| Date & Time problem | 15 Aug 2005 13:14 GMT | 2 |
I'm having trouble adding dates and times. I want to be able to create a schedule based on a few inputs in th first column: start date, start time and length. Length will also b input manually in each column. Each column afterwards would calculat
|