Selecting the first time a number appears
Dear Excel(lent) users,
I have a sheet in which I have the following columns:
A : Date
B: Number range, cummulatif +3 (positive estimation)
C: Number range, cummulatif -2 (negative estimation)
Now I want to know the following:
I want to know the date in A, which is the first date a certain number is
shown in Column B.
For instance:
A B C
---------------------------------------------
23-04-07 10 8
24-04-07 17 9
25-04-07 23 11
26-04-07 28 12
27-04-07 35 15
28-04-07 40 17
etc etc
The first time the number 17 appears in column B is on 24-04-07 so I want
that date as a return, the first time the number 17 appears in column C is on
28-04-07 so I want that date as a return.
Can you please help me ??
--
** Fool on the hill **
|