|
|
|
November 12th, 2009 04:40 PM
by Jamie
|
38 |
568 |
|
|
|
|
38 |
545 |
|
|
SUMPRODUCT and "--" by
Michelle
I don't understand why sometimes I have to use "--" before an argument in
the SUMPRODUCT fuction, and sometimes a "*".
Can anyone point me to a resource that...
( 1 2 3 ... Last Page)
|
|
37 |
361 |
|
|
Simplify formula by
Luke
Pardon the new thread about the same thing I posted earlier. I would like to
clean up the mistakes I made in my earlier quest.
In it's raw form my setup looks...
( 1 2 3 ... Last Page)
|
|
37 |
539 |
|
|
QDE (Quick Date Entry) by
Norman Harker
Hi Community of Excel Users!
This is a joint posting from 4 of the "regulars" to these newsgroups:
Bob Phillips, Frank Kabel, Ron de Bruin, and Norman...
( 1 2 3 ... Last Page)
|
|
37 |
2,810 |
|
|
Lookup in an Array by
Steve
Can somebody tell me how to look up a list of items in a column from
an array and then return the information in a cell that is in a column
which is the same...
( 1 2 3 ... Last Page)
|
November 6th, 2003 03:52 PM
by Steve
|
36 |
1,014 |
|
|
|
|
36 |
370 |
|
|
Text manipulation by
paulinoluciano
"Is there some VBA code which could delete all first, second or third
characters of a text? Could it be done to the three last characters
from this same text...
( 1 2 3 ... Last Page)
|
|
36 |
418 |
|
|
Average function by
Karen
I am trying to average time values over several weeks.
However, I would like to exclude time values that are 0.
Below is an example:
Wk 1 Wk 2 Wk 3 ...
( 1 2 3 ... Last Page)
|
|
35 |
770 |
|
|
|
|
34 |
1,058 |
|
|
Count Functions by
TSNS
Hi Everyone i am looking for a formula that would let me count the number of
cells with a value between zero and 15? is there something that would...
( 1 2 3 ... Last Page)
|
|
34 |
315 |
|
|
|
|
34 |
255 |
|
|
|
|
33 |
538 |
|
|
|
|
33 |
344 |
|
|
|
|
33 |
263 |
|
|
Multiple Item Lookup by
Chad F
I want to search sheet1 for all items that begin with "803" (803000 thru
803999) from A1:A4000 range and just list those item numbers in sheet2
starting in...
( 1 2 3 ... Last Page)
|
|
33 |
196 |
|
|
|
April 4th, 2005 02:17 PM
by Max
|
33 |
1,144 |
|
|
CountIf on Upper/Lowercase by
ws
COUNTIF (A1:A10,"=A") treats "A" and "a" the same
condition. Is there any way that I can differentiate the
them (thus uppercase and lowercase) in countif &...
( 1 2 3 ... Last Page)
|
|
33 |
347 |
|
|
Reverse PRICE function by
ingmar
Wondering if there is a way to calculate coupon rate of a bond based on YTM,
maturity, settlement date, and bond's price
essentially I am trying to back solve...
( 1 2 3 ... Last Page)
|
|
32 |
223 |
|
|
Validation of cell to enter data by
Frank Kabel
Hi
try using data validation ('Data - Validation).:
- Select the cells in column A (assumption you start in A1)
- enter the following formula in the data...
( 1 2 3 ... Last Page)
|
|
31 |
900 |