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 '19 at 21:27
  • sheet 1 is now example Oct 12 '19 at 21:57

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 '19 at 8:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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