Numbered Lists



I have a numbered list, in which i want the numbers to start from 1. 

I have used this list as dimension also have referred in some formulas. 

i entered wrong numbers when i was inserting numbers to the list. Now when i enter the numbers it starts from the next index number.

is there any way i cant reset it?


Capture.PNGCapture 2.PNG

Thank You

Best Answers


  • Hi Adhvi,


    We can reset the number list, after it reach its maximum 899,999,999 Million.

    So we can't reset in your case.


    ~Vignesh M

  • @Adhvi.Panata 

    A simple and more efficient answer, is to always ensure that you use a code for the numbered list and use that for the display name using CODE(ITEM(listname))