+ Reply to Thread
Results 1 to 3 of 3

UDF to number a sequence of numbers of letters

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    UDF to number a sequence of numbers of letters

    I am looking for a UDF or macro to number a list of numbers or words, so that they can be grouped together. The list would be sorted either alphabetically or numerically and when the alphabetic or numeric sequence "restarts", it will begin a new group number.

    Attached is an example workbook with two sheets - one for the alphabetic example and the other numeric. Column A contain the data, column B is where the UDF would be used.

    In both examples, the first character would determine the group number, as if it is "lower" than the cell preceding it, it would start a new sequence number.

    I am not sure if a normal Excel formula would even work, but regardless, to simply things, I would like a UDF. Thanks.

    SequenceExample.xlsx
    Last edited by Brawnystaff; 12-24-2014 at 09:16 PM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: UDF to number a sequence of numbers of letters

    Enter 1 in B2

    B3 formula : =MAX(B$2:B2)+(CODE(A2)>CODE(A3))

    filldown

  3. #3
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: UDF to number a sequence of numbers of letters

    Thanks Jindon. Did not think it would be that easy...You rock!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 11-26-2013, 05:21 PM
  2. The Sequence Of Letters/numbers
    By EmilR in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-11-2013, 12:28 AM
  3. Numbers With Letters Out of Sequence
    By llmarsh3 in forum Word Formatting & General
    Replies: 4
    Last Post: 11-26-2011, 12:41 PM
  4. Replies: 2
    Last Post: 10-13-2011, 02:35 AM
  5. How do I drag the sequence of letters/numbers?
    By rippingrudy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2007, 08:59 AM

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