+ Reply to Thread
Results 1 to 4 of 4

Group rows based on part of cell value

  1. #1
    Registered User
    Join Date
    06-19-2014
    Location
    Israel
    MS-Off Ver
    2010
    Posts
    16

    Group rows based on part of cell value

    Hello,
    I have a table that contains part numbers in one column and data about the part number in the other.

    The part numbers looks like these:

    3bk12345-000
    3bk12345-001
    3bk54321-000
    3bk54321-001

    The lust 3 digits (after the dash) are version of the part number.

    I would like to group the part numbers rows based on the part number and ignoring three digits after the dash.

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Group rows based on part of cell value

    I'm missing the point here. Could you post an example which shows where and how the basic data sorting feature doesn't work for you?

  3. #3
    Registered User
    Join Date
    06-19-2014
    Location
    Israel
    MS-Off Ver
    2010
    Posts
    16

    Re: Group rows based on part of cell value

    The problem is that in fact i have 4 different values (different part numbers).
    But actually it's to part numbers with difference of version (the last 3 digits).
    I need to group similar part numbers ignoring the version (the last 3 digits).

  4. #4
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Group rows based on part of cell value

    I still don't understand. Show an example, please, where and how the built-in Sort function fails your needs.

+ 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. [SOLVED] Create new rows based on part of the value in a cell
    By vjboaz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-19-2014, 02:24 PM
  2. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  3. [SOLVED] How to group rows based on one cell and get the sum of second cells
    By NoBullMan in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-13-2013, 01:07 PM
  4. Hiding Rows based on PART of Cell Item
    By Kitten4Him in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2012, 04:13 PM
  5. [SOLVED] VBA Code to Group Rows Based on Cell Contents
    By Pliskers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2006, 03:29 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