|
|
Internal Rate of Return (IRR) by
geek@smart
IRR function is unable to determine below cash flows.
0
-868055555.6
-156250000
-156250000
-166666666.7
-90617472.63
|
|
2 |
228 |
|
|
problem sorting by
ty
I can not get the following to sort correctly,
1
7
3
22 x 8
10 x 17
8 x 11
when I sort these they do as follows
1
3
|
|
2 |
213 |
|
|
Separating data in the same cell by
Jor
I'm needing to separate some data in columns. Here is a sample:
Thomas, Nehemiah JR 1,837.05 ; Tiller, Tanika 2,163.72 ; Tobin, Terri
1,182.66 ;
That is all...
|
|
1 |
145 |
|
|
Excel comments by
zonegrise
Hi,
Is possible to change the default font type in Excel comments? (not just the
size but the font itself)
|
|
1 |
223 |
|
|
Nested IF by
EZ[_2_]
I have a simple quesion about nested IF formula. I need to look up 3 values
each in a range, and if all matches show "Y" for yes otherwise "N" for no. My...
|
June 16th, 2009 10:03 PM
by EZ[_2_]
|
5 |
163 |
|
|
count if by
scooter
I am looking to count the number of times a value(ie "3") appears in one
column only if the column next to it has a different specific value(ie
"bob")....
|
|
1 |
153 |
|
|
|
June 16th, 2009 09:03 PM
by Mike H
|
3 |
138 |
|
|
|
|
2 |
137 |
|
|
2007 Defined Names Is Locked! by
D@SE
Running 2007 Vista, opened one of my programs of 2003 in compatibility mode,
went to Formulas, to Defined Names but it appears that it is locked. Defined...
|
June 16th, 2009 08:36 PM
by D@SE
|
2 |
120 |
|
|
|
|
5 |
152 |
|
|
Spec. Sheet by
Muskrat24
I am using excel to create a estimate product list and a spec. sheet of the
products selected.
on sheet 1 named "Estimate Template" I have the choice such as...
|
|
8 |
133 |
|
|
using vlookup and hyperlink by
MJ
I am using VLookup in column “D” that replicates a number from column “B”.
This works fine. What I would like to do is type the number into “B”...
|
June 16th, 2009 08:16 PM
by MJ
|
6 |
123 |
|
|
Excel 2003: Count total days elapsed by
watermt
I need to count the total number of days (counting all days of the week)
elapsed between process 1 through 12. Using the m/d/yyyy hh:mm cell
formatting, not...
( 1 2)
|
|
12 |
348 |
|
|
Determie Trend by
John Smith
im looking for a function to determine the trend of sales. i have 24 months
of sales in columns b:y. All i want to do is determine if sales are trending
up...
|
|
2 |
127 |
|
|
|
|
1 |
119 |
|
|
Vlook up problem by
Sarahneedshelp
Hi,
I am trying to do a simple vlookup which i have used lots before but this is
this first time with using excel 2007 and something seems to be going...
|
|
3 |
122 |
|
|
|
|
2 |
153 |
|
|
sorting problem 10 comes before 8 by
ty
When sorting a list in a column where some are single digits and some are
such as :
1
3
8
8 x 12
10 x 10
they sort as follows
1
3
|
June 16th, 2009 06:51 PM
by Marcelo
|
2 |
140 |
|
|
Last Date Modified by
snickers22
I need help in setting up a cell to reflect the Last Date Modified of a Word
Document. I did try Google but I don't fully understand the code that they
are...
|
|
2 |
93 |
|
|
|
June 16th, 2009 05:59 PM
by FStJ
|
2 |
115 |