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?


bumped to the homepage by Community 2 days ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

  • "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? – marikamitsos Oct 12 at 21:27
  • sheet 1 is now example – Tomaž Novak Oct 12 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 – Tomaž Novak Oct 13 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.