|
|
|
|
1 |
228 |
|
|
|
May 20th, 2010 04:41 PM
by Don M.
|
4 |
314 |
|
|
If function help by
Mezani
I have two cells that each have drop down lists. The first cell has the text
yes and no, If i choose yes i want the second cell to return N/A for example,
and...
|
|
4 |
246 |
|
|
Sumproduct seems off... HELP PLEASE! by
Hile
WinXPPro SP3, Excel 2k
OK so I'm using sumprod and something just doesn't seem right. Col B should
clearly have a higher weighted average than Col C. Can...
|
May 20th, 2010 04:24 PM
by Hile
|
3 |
210 |
|
|
|
|
2 |
332 |
|
|
Totals for month if 2 conditions are met by
Carrach
Hi,
Wonder if anyone could put me on the correct track?
I need to show the totals for the following:
(if target_name_sheet1=target_name_this sheet)and(if...
|
|
3 |
200 |
|
|
How to Rank Name? by
Matlock
I have a Power Ranking Excel Book for my partner Restaurants that lists us
from 1st - 14th in different categories through the year.
------- Example 1...
|
|
4 |
240 |
|
|
|
May 20th, 2010 02:55 AM
by ferne
|
5 |
328 |
|
|
Filter formula by
Michel
HI
I have a database with repeated informations as listed below and is
increasing daily
Nat Firm Name
SPAIN VIAJES EL CORTE INGLES
SPAIN VIAJES EL CORTE...
|
May 20th, 2010 12:25 AM
by Max
|
1 |
149 |
|
|
function help! by
CT
I want to find if one item sold this month is also sold in last month. If
so, return the quantify sold last month. How do I do that? thanks a lot.
that...
|
May 20th, 2010 12:12 AM
by Max
|
1 |
131 |
|
|
Summing multi-level bill of material by
Nathan356
All,
I have a multi-level bill of material and I want to create a
function that will sum it properly without having to sum up each level
manually. Here is...
|
|
0 |
137 |
|
|
|
|
2 |
213 |
|
|
SumProduct using Date Range by
NMK
I need to sum a values using multiple criteria and a date range.
Example - I need to sum the total amount of all investors that have an "N"
in the n/e...
|
|
1 |
196 |
|
|
SUMPRODUCT with date range by
NMK
I need help with a sumproduct formula that will sum with three difference
types of criteria and also use a date range? Any suggestions?
|
|
1 |
260 |
|
|
networkdays alternative by
Gabe
I have several people that are not familiar with the Analysis Toolpak, is
there a work around for the networkdays function? I just have two dates in
B33...
|
|
2 |
175 |
|
|
pivot table by
Stephanie
how do I do a pivot table with data that is on multiple worksheets?
|
|
1 |
139 |
|
|
|
|
1 |
156 |
|
|
|
|
5 |
144 |
|
|
Text Functions by
Charlie
I'm trying to split a text string ... Apart from it not working quite right
yet! I'm sure I've over complicated it.
Base Data "Path":
\\SERVER\X$\data\Team...
|
|
2 |
203 |
|
|
|
|
40 |
2,463 |