Oops, typo correction:
Put in X2: =IF(OR(C2="",C2=0),"",ROW())
Copy down as many rows as data is expected
in the table, say down to C2000?
Last line in above should read as
in the table, say down to X2000?
--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---
|