|
|
XIRR function not defined? by
Alex
For some reason the XIRR function on the version of Excel 2003 on my new
computer is not working. When I enter it the "#NAME?" response comes up, and
when I...
|
February 21st, 2008 10:04 PM
by George T
|
3 |
110 |
|
|
compould yield calculation by
alex
The yield function in excel gives the simple yield calculation, while am
looking for the compound yield calculation thanks
|
|
1 |
62 |
|
|
Time Calculation by
alex
Hello experts,
Question on how to add hours to a time...
E.g., I have a time in A1 (let's say 6:06 AM)
I want to add an amount to A1 (let's say 8.5 hrs in...
|
|
5 |
70 |
|
|
Nesting named formulas by
Alex
I want to go around the maximum of 7 nested functions in Excel. I have
created two named formulas as described on...
|
December 21st, 2007 03:10 PM
by Alex
|
2 |
103 |
|
|
Data Validation - Insert Row by
Alex
Hi,
I have been trying to figure this out but, can’t seem to find a solution.
Please Help.
Cell A1 will show lists of categories (fruits or veggies), cell...
|
February 29th, 2008 05:48 PM
by Pete_UK
|
3 |
78 |
|
|
Range by
alex
Hello experts,
using Excel '03...
I'm trying to write a formula that checks a range of cells, basically
modifying this formula:
if(B55="","1","2")
to...
|
March 7th, 2008 07:24 PM
by alex
|
2 |
77 |
|
|
If function with Another Function by
Alex
I have a function that extracts the number only from a string. Example: Cell
A1: Fund: fhks99al, Cell B1 with function =NumberOnly(A1) will result in 99. ...
|
|
3 |
69 |
|
|
|
|
3 |
108 |
|
|
Sort Chart Values by
Alex
I have tried Jon Peltier's example on linking table to sort data for charting
by using the LARGE function, to no avail. My data is set up different than...
|
July 14th, 2008 07:24 PM
by Alex
|
0 |
73 |
|
|
SNMP functions? by
Alex
Hi
Does anyone know about Excel add-ons or functions for SNMP queries, like
SNMP GET, GETNEXT, GETBULK, etc.
TIA
Alex
|
October 24th, 2007 03:33 PM
by Alex
|
0 |
60 |
|
|
Help with Concatenation by
alex
Hello all,
I'm trying to concatenate two cells with dates.
The concatenation works; however, the dates change formats.
Formula: =concatenate(i34," and...
|
August 28th, 2007 06:09 PM
by alex
|
3 |
87 |
|
|
|
|
5 |
108 |
|
|
|
June 20th, 2007 04:01 PM
by rayh
|
2 |
63 |
|
|
Freeze Panes Shared workbook problem by
Alex
I am using Microsoft Excel 2002, and was wondering if there is away around my
problem.
Currently often in the shared workbooks when freeze panes is used, it...
|
May 16th, 2007 03:07 PM
by Alex
|
0 |
113 |
|
|
plus 1 by
alex
Hello Experts,
I have an xls worksheet in which users paste a date from another
application.
Once pasted, I want to increase the value by one day (in the...
( 1 2)
|
|
10 |
85 |
|
|
return partial string by
alex
Hello experts,
I'm attempting to write a function that will return part of a name.
E.g., I have the name John Doe in cell A1. I want the cell B1 to
populate...
|
July 20th, 2007 11:41 AM
by alex
|
5 |
118 |
|
|
Sum If by
Alex
Hi - can comeone help me please
Into B21 I want to add the values of rows B2:B18 where ant of the rowsC2:C18
contain the word "Premier"
tks
|
July 24th, 2007 10:46 AM
by Alex
|
3 |
114 |
|
|
|
August 1st, 2007 12:48 PM
by Alex
|
2 |
94 |
|
|
Minimum Value by
Alex
Hi, using an accounting format on Row E, I am trying to extract thje lowest
value from E6:E34 where B6:B34 = 2006.
I am using:...
|
August 1st, 2007 03:44 PM
by Toppers
|
2 |
148 |
|
|
Vlookup based on 2 criteria by
Alex
I have a table that has three values seen below. I would like to
transfer/copy these values into a new worksheet that has the date listed
horizontally on...
|
July 21st, 2008 07:15 PM
by Alex
|
2 |
73 |