+ Reply to Thread
Results 1 to 11 of 11

add increment identifier to unique values

  1. 02-19-2013, 03:59 PM #1
    hluk
    hluk is offline
    Registered User
    Join Date
    07-09-2008
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    91

    add increment identifier to unique values

    looking to add a number to identify each category

    so example

    column 1
    Sports
    Food & Nutrition
    Food & Nutrition
    Health & Fitness
    Food & Nutrition
    Food & Nutrition
    Food & Nutrition
    Food & Nutrition
    Food & Nutrition
    Food & Nutrition
    Food & Nutrition
    Food & Nutrition
    Food & Nutrition
    Food & Nutrition
    Food & Nutrition
    Sports
    Sports
    Sports
    what formula can i use to drag down so that column 2 becomes

    Sports 1
    Food & Nutrition 1
    Food & Nutrition 2
    Health & Fitness 1
    Food & Nutrition 3
    Food & Nutrition 4
    Food & Nutrition 5
    Food & Nutrition 6
    Food & Nutrition 7
    Food & Nutrition 8
    Food & Nutrition 9
    Food & Nutrition 10
    Food & Nutrition 11
    Food & Nutrition 12
    Food & Nutrition 13
    Sports 2
    Sports 3
    Sports 4
    let me know if i am not making sense... hahahahah

    thanks for the help in advanced!
    Reply With QuoteRegister To Reply
  2. 02-19-2013, 04:06 PM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: add increment identifier to unique values

    If your list starts with A1 in a separate column use

    Please Login or Register  to view this content.
    copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 02-19-2013, 04:07 PM #3
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: add increment identifier to unique values

    assuming the list starts in A1, this in B1:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Drag down

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post
    Reply With QuoteRegister To Reply
  4. 02-19-2013, 04:12 PM #4
    hluk
    hluk is offline
    Registered User
    Join Date
    07-09-2008
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    91

    Re: add increment identifier to unique values

    awesome!!!

    +rep
    Reply With QuoteRegister To Reply
  5. 02-19-2013, 04:15 PM #5
    hluk
    hluk is offline
    Registered User
    Join Date
    07-09-2008
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    91

    Re: add increment identifier to unique values

    sorry, thought i had it down but one more question relating to this

    if i had
    Sports 1
    how do i add 1 to it so it becomes Sports 2
    Reply With QuoteRegister To Reply
  6. 02-19-2013, 04:21 PM #6
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: add increment identifier to unique values

    Would this be in the same list as the first part of the question?
    Reply With QuoteRegister To Reply
  7. 02-19-2013, 04:26 PM #7
    hluk
    hluk is offline
    Registered User
    Join Date
    07-09-2008
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    91

    Re: add increment identifier to unique values

    yes, so the 3rd column, i need to add a custom number to it depending on situation
    Reply With QuoteRegister To Reply
  8. 02-19-2013, 04:30 PM #8
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: add increment identifier to unique values

    Like this perhaps??....based on info in Post # 1

    btw thnx for the rep
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 02-19-2013, 04:33 PM #9
    hluk
    hluk is offline
    Registered User
    Join Date
    07-09-2008
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    91

    Re: add increment identifier to unique values

    Quote Originally Posted by Ace_XL View Post
    Like this perhaps??....based on info in Post # 1

    btw thnx for the rep
    no problem

    hum, the 3rd column i need to increment column 2 by a set value (plus 1 or plus 2 to be determined)
    Reply With QuoteRegister To Reply
  10. 02-19-2013, 04:38 PM #10
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: add increment identifier to unique values

    In 3rd column use

    Please Login or Register  to view this content.
    Change the highlighted part as per requirement. See attached.

    Hope this helps
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 02-19-2013, 04:44 PM #11
    hluk
    hluk is offline
    Registered User
    Join Date
    07-09-2008
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    91

    Re: add increment identifier to unique values

    Ace_XL = awesome!!!

    everything resolved now
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1