In article , Max
writes
One way - use an adjacent helper col

Assuming numbers running in Y2 down
Put in Z2: =IF(Y20,"active",Y2)
Copy down. Kill the formulas in col Z with an "in-place" copypaste special
as values. Delete col Y.

If you want any blank cells in col Y to return as "blanks", ie:""
then use instead in Z2:
=IF(Y2="","",IF(Y20,"active",Y2))


Max

excellent , thanks. That fixed it.

Very grateful.



Best Wishes


Colin