View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default

Put in say, D1:

=IF(OR(COUNTIF($A$2:A2,A2)1,B2=0),"",ROW())


Sorry, typo: "Put in D1" above should read as "Put in D2"

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