+ Reply to Thread
Results 1 to 6 of 6

numbering components within assemblies

  1. #1
    Registered User
    Join Date
    06-08-2015
    Location
    Glasgow, UK
    MS-Off Ver
    2019
    Posts
    37

    numbering components within assemblies

    Hello

    I have a csv file with 1,040,976 rows.

    Column A contains the full assembly names, within the spreadsheet there are 42,855 different assemblies.

    The other columns contain details of components within the assemblies, I need to retain the order of the assemblies and their components but also populate another column with a sequential number for each assemblies components (parts for each assembly) 1-10 (or however many components make up that assembly).

    I figure I need to mark the duplicate groups of rows and somehow label each row within the group.

    I would really appreciate some help!

    Thank you.

    Charlie

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: numbering components within assemblies

    Please post a small file illustrating what is required.

  3. #3
    Registered User
    Join Date
    06-08-2015
    Location
    Glasgow, UK
    MS-Off Ver
    2019
    Posts
    37

    Re: numbering components within assemblies

    I've attached a small section of the csv file. I have manually populated the "LOP NUMBER" column and I need to find a way to populat the 1,040,976 lines in the same sequential way.
    Thank you!
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: numbering components within assemblies

    Try .

    =COUNTIF($A$2:A2,A2)

  5. #5
    Registered User
    Join Date
    06-08-2015
    Location
    Glasgow, UK
    MS-Off Ver
    2019
    Posts
    37

    Thumbs up Re: numbering components within assemblies

    Thank you so much! That's doing exactly what I wanted. Have a good day!

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: numbering components within assemblies

    If you are happy with the solution, could please mark the thread as SOLVED ("Thread Tools" at head of first post).

    Thank you.

+ 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: 2
    Last Post: 06-27-2014, 06:40 AM
  2. Create a list of bought-out items for various assemblies
    By aimeelou2006 in forum Excel General
    Replies: 2
    Last Post: 04-02-2013, 05:43 PM
  3. generated parts list from list of assemblies
    By staticchanger in forum Excel General
    Replies: 1
    Last Post: 06-24-2012, 05:20 PM
  4. Problem with cell assemblies
    By desonny in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-09-2011, 12:22 AM
  5. bill of material, assemblies
    By jamesw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2011, 01:53 PM
  6. Updating Inventory for Assemblies
    By hpmachining in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2010, 02:47 PM
  7. [SOLVED] Where is documentation for the C# Office XP/2003 Primary Interop Assemblies???
    By Stefani in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2005, 11:06 PM

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