Forum Discussion

deansonline's avatar
deansonline
Copper Contributor
May 06, 2020

Excel number ordering

Hi Everyone,

 

My name is Dean, I've spent the last few weeks struggling to learn excel and now i need a little help if possible...

 

Does anyone know of way to quickly number each name as I've done above and then to start again back to the number 1 after you hit the date in the blue line?... I have 1000"s of rows to do this to.

 

been doing this for hours and have no idea if you can?..

 

Thanks

excel
Excel on Mac
Formulas and Functions
office 365

9 Replies

  • jukapil's avatar
    jukapil
    MCT
    May 06, 2020

    deansonline yeah you can do it.  put this formula below as I am considering that your data in image starts from 1

     

    In Cell A4,

     

    =If(isnumber(left(B4,1)*1),"",B3+1)

     

    and drag this formula till last Row. Hope this works.

    • deansonline's avatar
      deansonline
      Copper Contributor
      May 06, 2020

      jukapil 

       

      Thanks for getting back to me so quickly, unfortunately ive copied and pasted it and its still counts without resetting.

       

      I don't know if this will help....

       

      i have attached another picture, I have a column that i don't need and that i am happy to copy and paste over it. as soon as there is a gap i need to it reset back to 1 and count again.

       

      Thank you very much for your time

       

       

      • jukapil's avatar
        jukapil
        MCT
        May 06, 2020

        deansonline seems your dates are different format. Use the same formula and drag it till end. Then Please activate the filter in Column B and do filtering by when contains = 2020. This will filter the date rows then select Column A and press delete. Then it will reset the numbers.

         

        Hope your name does not contain 2020

         

Resources