I want to have auto numbering dependent on cell drop down box in helper column so i can sorted out.

If someone pick Start in A2 to have number 1 in B2.
Then if they skip one or two and chose Start A4 in B3=2,
A6 in B6=3
A3 in B3=4
Then auto sort the sheet based on B column?


  • "A4=2 in B3, A6=3 in B6 A3=4 in B3" ???? I am lost. Could you please give the expected result as an example on the sheet? Oct 12, 2019 at 21:27
  • sheet 1 is now example Oct 12, 2019 at 21:57

1 Answer 1


Try this formula in cell B2:

=ArrayFormula( IF(A2:A15="Start",row(A2:A15)-1,"")) 

We make use of the function ROW. ROW returns the row number of a specified cell..
Please read more about ROW here

  • I dont want to count rows but sequence when "Start" is inishiated in row A Oct 13, 2019 at 8:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.