View Single Post
  #6   Report Post  
Ravi
 
Posts: n/a
Default

Thanks guys. That was very useful and successful.

"Max" wrote:

Perhaps another play to try in the interim ..

Assuming only a single cell within I15:O15 would evaluate to 0 at any
time, try, array-entered:

=IF(ISNA(MATCH(TRUE,I15:O150,0)),"",MATCH(TRUE,I1 5:O150,0)+8)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----