|
|
|
|
4 |
185 |
|
|
Break a link/formula but keep the data? by
Trang
I receive a file where the sender used a link to his own source, but he does
not send me his source. When I open the file I can see the value of the
linked...
|
|
4 |
153 |
|
|
SUBTOTAL and then count with criteria by
Jane
Afte auto-filtering specific categories, I then need to count values =1200,
=3600, etc. I'm familiar with SUBTOTAL but basically need a SUBTOTALIF type
of...
|
|
3 |
115 |
|
|
Fourier Analysis by
Bruce
How does one use the Fourier Analysis in the Data Analysis Tools?
Are there any examples available?
|
|
1 |
238 |
|
|
|
January 13th, 2005 12:08 PM
by Max
|
1 |
65 |
|
|
Compound interest calculation by
Ira Hayes
I think my bank is underpaying me interest on a 5 year certificate of
deposit.
How can I calculate the interest I should get on, say, $2,500 for a five
year...
|
|
2 |
197 |
|
|
Average by
Hague2
Column A1:A10 has a 0 or 1 in each cell, Column B1:B10 has numbers. I want
to be able to select the 0 (zero's) in Column A and AVERAGE only those
numbers at...
|
|
2 |
104 |
|
|
|
January 13th, 2005 02:57 PM
by David
|
7 |
162 |
|
|
Formula needed by
Edgar Thoemmes
I need to be able to work out the percentage of certain orders placed by
certain groups.
In column A I have numbers which determines what kind of order it is,...
|
|
3 |
87 |
|
|
VLOOKUP is not sufficient by
ASHISH SRIVASTAVA
How to map items of different columns and to get result in different column
when exactly matched?
|
January 13th, 2005 03:45 PM
by JulieD
|
1 |
95 |
|
|
|
|
0 |
220 |
|
|
excel by
Blessingspoint
What is the formula for dividing a number by 4 in excel
|
|
1 |
77 |
|
|
multiple vlookups by
inthestands
I need to compare matches for different months for customers and the
products
that they purchase. So I need to match three items; the customer, the
item,
and...
|
|
0 |
248 |
|
|
|
|
1 |
149 |
|
|
=SUMPRODUCT and =IF by
Jim
I currently use the following to count the number of occurrences that time
shows on my report. This is a great...
|
January 13th, 2005 08:25 PM
by Jim
|
3 |
92 |
|
|
Nested if, sum & vlookup Function by
Trying to excel in life but need help
I will try to explain clearly what I am trying to accomplish. I hope this
makes sense.
I work in the transportation iindustry and have the dubious pleasure...
|
|
4 |
256 |
|
|
excel by
Blessingspoint
What is the formula for dividing a number by 4 in excel
|
|
5 |
89 |
|
|
|
|
4 |
345 |
|
|
|
|
0 |
429 |
|
|
% of Schedule Calculation by
Mike Pandher
Hi all!!
Unique problem here - at least I have not found the answer yet. I am certain
one of you can help.
I have the following 3 columns:
Report...
|
|
1 |
112 |