Forum Discussion

erhang's avatar
erhang
Helper II
8 years ago
Solved

Counting lines

Hi there ;   i want to count one of column and want to give number  them wit a new column.Which formula that i can use , could you help me pls.   in below example i want to create "number" column...
Need Help
  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    Hi erhang

     

    You need to go to the data tab, then go to edit query / power query editor - Add new column

     

    Then you can add Index column from 10000001 with an increment of 1 for example

     

    - Quentin

quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hi erhang

 

You need to go to the data tab, then go to edit query / power query editor - Add new column

 

Then you can add Index column from 10000001 with an increment of 1 for example

 

- Quentin

erhang's avatar
erhang
Helper II
8 years ago

thanks for the solution dear quentin_vigne