Column Serial number

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

  1. SpeedyRocketeer
    Offline

    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
    Online

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,659
    Thanks Received:
    2,114
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,484 / 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
    Offline

    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
any way to number automatically number rows in iworks numbers
,
automatically number rolls in numbers app
,
check ipad manufacture date
,
ipad date of manufacture
,

ipad numbers automatic numbering

,
ipad serial numbers manufactured date