Date identification based on the value

[SAN04]

In the attached sheet, need to identify the particular date from date range on which the value 0% is becoming 70%.
Also in the same way need to identify the particular date from date range on which value 10,000% is coming first time.

Please help

Thanks

 

[Peter Bartholomew]

= LOOKUP(70%, percent, date )
An improved function is also about to be released
= XLOOKUP(10000%, percent, date, -1 )

 

[bosco_yip]

In B5, and B6, enter criteria 70% and 10,000%

In C5, copied down :

=INDEX($1:$1,MATCH(B5,INDEX(ROUND($2:$2,2),0),0))

Regards
Bosco

 

[SAN04]

Thanks Bosco !

But always the value will not be 70%, it could be any number % . So, pls provide the formula accordingly

 

[SAN04]

Thanks Bosco !

But always the value will not be 70%, it could be any number % . So, pls provide the formula accordingly

Also we cannot round off the percentage.

In this i have to capture date on which first value more than zero is coming and a date on which the 100000% comes first

 

[SAN04]

Hello all,

In the attached sheet, i have to capture date on which first value more than zero is coming and a date on which the 100000% comes first using formula.

Also, please donot round off values.

Please help!

 

[bosco_yip]

The 1st date after zero % :
=INDEX(1:1,MATCH(1,INDEX(ISNUMBER(2:2)*(2:2>0),0),0))

The 1st date of 1st 10,000% comes :
=INDEX(1:1,MATCH(10000%,2:2,0))

Regards
Bosco

 

[SAN04]

Thanks Bosco!