Column Serial number

Discussion in 'iWork Forum' started by SpeedyRocketeer, Sep 11, 2011.

  1. SpeedyRocketeer

    SpeedyRocketeer iPF Noob

    Joined:
    Sep 8, 2011
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    UK
    Ratings:
    +0 / 0
    In Apple's Numbers for iPad...is it possible to have automatic serial numbers in first column? so essentially when i input some data in second column the associated first column would populate row number automatically.
     
    Last edited: Sep 11, 2011
  2. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,016
    Thanks Received:
    2,329
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,810 / 1
    There is no easy way, but you could probably create a formula that would test the first cell, then display something if the cell contained a non-zero value. To get serial number you woul need to calculate it based on cell position or the value in the previous cell or grab it from another table of pre-created numbers.

    That is all I can think of at the moment.
     
  3. 88raymond

    88raymond iPad Fan

    Joined:
    Jul 22, 2011
    Messages:
    285
    Thanks Received:
    5
    Trophy Points:
    0
    Ratings:
    +5 / 0
    it will be automatic if you program the first column... using a combination of the if() function, and the A1+1 formula copied downwards.
     

Share This Page

Search tags for this page
automatically number rolls in numbers app
,
check ipad manufacture date
,
ipad date of manufacture
,

ipad numbers automatic numbering

,
ipad serial numbers manufactured date