Auto populate sequential ID numbers based on any text entered into adjacent cells

WS attached

When any text is entered into sheet ‘LG’ K06:K1005, an auto populated sequentiql number will appear in adjacent column M6:M1005.
Populated numbers will start at 1, then 2 and so on each time any text is entered into the next cell in K6:K1005.
If no text is entered in the next cell then no number will populate.

You can use this formula in cell M6:

=IF(K6="","",MAX(M$5:M5)+1)

Then copy down.

Hope this helps.

Pete

thanks alot, works really well