+ Reply to Thread
Results 1 to 5 of 5

Identifying groups of lines between start and end indicators

  1. #1
    Registered User
    Join Date
    07-02-2010
    Location
    Hatfield, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Identifying groups of lines between start and end indicators

    I have a set of data which represents orders and the lines within those orders. In the attached example there are three orders. Within an order there are lines for specific materials which represent the start and end of a bundle of products (70000140 and 70000141 in the attached sample). An order may have one or more bundles. There may be lines which are not in bundles at all (i.e. not between a start line and an end line). I need to create an identifier for each bundle, and then a sequence number of each line which is within each bundle (columns E and F in the attached, created manually for this example). I feel sure this can be done using functions such as INDEX and MATCH, but I can’t work out how to do it. All help and advice would be very much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Identifying groups of lines between start and end indicators

    In F2 copied down:

    =IF(E2="","",COUNTIF($E$2:$E2,E2))
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Identifying groups of lines between start and end indicators

    Hi all- I entered the start and end codes in I2:I3. Paste the following in F2, copied down:
    Please Login or Register  to view this content.
    ...and in E2, copied down:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by leelnich; 02-04-2018 at 12:02 PM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee

  4. #4
    Registered User
    Join Date
    07-02-2010
    Location
    Hatfield, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Identifying groups of lines between start and end indicators

    Brilliant solution, thanks so much. (For other readers, great example of using COUNTIF and COUNTIFS)

  5. #5
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Identifying groups of lines between start and end indicators

    You're welcome, thank you for the feedback!

+ 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. Help with identifying groups and sets
    By needyohelp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2016, 12:53 PM
  2. [SOLVED] Identifying additional lines
    By shiser in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-10-2014, 09:08 AM
  3. [SOLVED] Create a Function that has several lines of if then - trouble identifying the Row
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-09-2012, 11:29 AM
  4. Identifying duplicate lines using multiple values
    By dantray in forum Excel General
    Replies: 8
    Last Post: 02-09-2012, 10:51 AM
  5. identifying start and end dates in a series?
    By RealEstateFinan in forum Excel General
    Replies: 13
    Last Post: 07-15-2007, 07:26 PM
  6. Identifying Where Values Start and Stop in a Row
    By Gamse in forum Excel General
    Replies: 0
    Last Post: 08-30-2006, 11:24 AM
  7. Identifying and separating groups of data.
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-24-2005, 12:05 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