|
|
sum calculation by
shar
How would I go about returning the sum of the QTY column for each unique
date. (You will notice that there are some rows with duplicate dates.) This
data...
|
March 24th, 2005 05:16 PM
by
|
2 |
75 |
|
|
dsum with date criteria by
Michel from Belgium
Hi everybody,
I am working with Excel XP.
I have a database with 2000 records and dbase formulas (mainly dsum) to
calculate
results in date ranges. The...
|
|
3 |
408 |
|
|
ACCRINT formula yields incorrect result by
Onurali_k
I applied the ACCRINT formula to a security with
maturity: 09 Feb 2010
issue: 09 Feb 2005 (adjusted to exclude coupons already paid)
first interest: 09 Feb...
|
|
7 |
169 |
|
|
|
March 24th, 2005 05:52 PM
by JulieD
|
1 |
283 |
|
|
|
|
17 |
234 |
|
|
|
|
3 |
198 |
|
|
CORREL versus r-squared by
Shell
Why do I get different values for the same arrays when I
run CORREL and ad r-squared value to a scatter plot?
|
|
3 |
108 |
|
|
Formula Trouble by
JS
I would like data to be displayed in a different cell.
e.g. formula would be in a cell in sheet2, but saying something like, if
sheet1 A10, then print the...
|
March 24th, 2005 06:55 PM
by JulieD
|
7 |
94 |
|
|
|
|
1 |
88 |
|
|
moving text by
Cheryl
I would like to move several rows from one part of work page to another. How
do I do this without having to create new rows where I want this text? I
have...
|
|
1 |
66 |
|
|
Combo box question by
Frepez
Hi I want to create a combo box and I want it to list values from a specific
column.
I'm making a price list so that I can use a filter process to get the...
|
|
4 |
91 |
|
|
LOOKUP or VLOOKUP by
Bennie
Hello! I have a very large spreadsheet and I need to search it for a
duplicate invoice numbers. I am entering invoice numbers in the first seven
columns. ...
|
March 24th, 2005 07:45 PM
by Bennie
|
4 |
111 |
|
|
|
|
3 |
146 |
|
|
|
|
1 |
81 |
|
|
|
|
2 |
288 |
|
|
IF function... not equal to by
cj_singer
How do I set the IF function to do a "not equal to" or "does not equal" or
something similar? As opposed to =, , , =, =.
|
|
1 |
92 |
|
|
Explain these please by
Sal
Hello you techies out there. I have been asked to explain the following -
can anybody make clear to me so I acn in turn explain to others. Thank you.
=IF('TL...
|
|
1 |
174 |
|
|
Remember a previous cell's value by
Goody
I run a fantasy racing league with some friends. I am trying to find out how
to return a previous cell's value, such as a player's rank from last week. I
am...
|
March 24th, 2005 08:45 PM
by bj
|
5 |
96 |
|
|
|
|
1 |
271 |
|
|
|
March 24th, 2005 08:57 PM
by bj
|
2 |
126 |