|
02-23-2022, 08:52 AM
|
|
Novice
|
|
Join Date: Feb 2022
Posts: 14
|
|
Quote:
Originally Posted by kilroyscarnival
I've applied a numbering column where the column's cells are locked, and where the numbers don't show up until he starts to type content in the next (B) column.
First number cell =IF(B2="","",1)
Subsequent number cells =IF(B3="","",MAX(A$2:A2)+1)
The latter, when filled down, becomes =IF(B17="","",MAX(A$2:A16)+1) etc.
|
Thanks for this but this does not work if someone decides to insert a line in the middle of the data
|