For the indexing column
in A2 (copied down)
=COUNTA(A$1:A1)+MIN(A$1:A1)
A1 would hold the starting value.
Note that this works for blank Cells, cells containing "" will foul it.
For the indexing column
in A2 (copied down)
=COUNTA(A$1:A1)+MIN(A$1:A1)
A1 would hold the starting value.
Note that this works for blank Cells, cells containing "" will foul it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks