Selecting the first time a number appears
If D2=17 then:
=IF(ISNA(INDEX($A$1:$A$6,MATCH(D2,$B$1:$B$6,0)))," ",INDEX($A$1:$A$6,MATCH(D2,$B$1:$B$6,0)))
=IF(ISNA(INDEX($A$1:$A$6,MATCH(D2,$C$1:$C$6,0)))," ",INDEX($A$1:$A$6,MATCH(D2,$C$1:$C$6,0)))
HTH
"Jaydubs" wrote:
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 **
|