+ Reply to Thread
Results 1 to 3 of 3

auto item number when a cell has figure

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    philippines
    MS-Off Ver
    Excel 2010
    Posts
    2

    auto item number when a cell has figure

    i have a list of item on column A1 to A1000. and when I manually put a figure in column B i want an auto item number on its column C.

    ex:

    A (list) B (manual) C (auto item number)
    APPLE 10 1
    PAPAYA
    ICECREAM 5 2
    SALAD 8 3

    i hope you understand. :-)

  2. #2
    Registered User
    Join Date
    02-12-2013
    Location
    philippines
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: auto item number when a cell has figure

    i attached the sample

    Capture.JPG

  3. #3
    Registered User
    Join Date
    07-03-2011
    Location
    Mumbai, India
    MS-Off Ver
    2007
    Posts
    18

    Re: auto item number when a cell has figure

    If your table is A1:C8, input in C2:
    =IF(B2<>"",MAX($C$1:C1)+1,"")
    copy down till required.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1