How can I do this???

[panosmgr]

In fact I need an "excel brain" to help me for some calculations.


I have in excel :

DATE COUNTRY RATE1 RATE2
COL(A) COL(B) COL(C) COL(D)
3 GER 1.50 2.30
3 FRA 1.15 6.50
4 GER 1.20 6.00
4 GER2 1.40 5.50
4 IT1 1.80 3.60
6 IT2 3.50 2.11
7 POL 4.10 1.75
7 SP1 1.56 8.90
9 SP2 2.70 4.50



I want to add a formula in cell E1 that shows me how many times th
lowest rate of colC or colD appears from the 1st date of the mont
until... yestrday (in above example ..until 2) for selection GER.
colA are numbers now, but maybe in future I change to date format.
The formula must recognize itself which rate (from C1 and D1 are th
lowest).


I looking desparately for any help

Thanks
ko

 

[Bob Phillips]

I don't understand where the result of 2 comes from. The lowest value is
1.15, and I only see that once in the table.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[panosmgr]

I write by myself all numbers and data in collumns A to D and I want i
colE the formula I ask.

For above example the result must be : 0 (Because their is no othe
1.50 in Ger before 3rd of the currect month).

How can I make this formula

 

[Bob Phillips]

Is this what you want

=SUMPRODUCT(--(B1:B25="GER"),--((C1:C25=MIN(C125))+(D125=MIN(C125))))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)