Sequential numbering with gaps

The first sequential number is going to be somewhere between 590 and 620 because of historic data, so let's say 601. I tried adding that to the formula but it returned #VALUE where there were blanks.

If you want to start at 601 then try this formula in J10 copied down

=IF(K10="","",COUNTIF(K$10:K10,"?*")+600)

Originally Posted by tghcogo

Thanks, it works a treat.

As a matter of interest what does the "?*" do.

It's just a way of counting text without counting "formula blanks". If your blanks are genuinely blank [ and not formulas that generate ""] then you could use COUNTA which counts text and numbers....[but also formula blanks]