+ Reply to Thread
Results 1 to 9 of 9

How to consolidate values in cells in order and remove duplicate?

  1. #1
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    How to consolidate values in cells in order and remove duplicate?

    How to consolidate excel cell in order and remove duplicate?

    Value of Excel Cell A1 : SR4.2/22-SR4.2/24
    Value of Excel Cell A2 : SR4.2/23+1,SR4.2/COL/1
    Value of Excel Cell A3 : SR4.2/22,SR4.2/21

    How to make the value of excel cell B1 to B6:
    SR4.2/21,SR4.2/22,SR4.2/23,SR4.2/23+1,SR4.2/24,SR4.2/COL/1
    Last edited by london7871; 03-21-2016 at 09:50 PM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: How to consolidate values in cells in order and remove duplicate?

    There's no SR4.2/23 in your data - did you want to remove the extra 2/22 or make it be a 2/23??
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: How to consolidate values in cells in order and remove duplicate?

    well - this will do what you've asked:

    Please Login or Register  to view this content.
    Last edited by xladept; 03-22-2016 at 02:03 PM.

  4. #4
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to consolidate values in cells in order and remove duplicate?

    Please note that SR4.2/22-SR4.2/24 = SR4.2/22, SR4.2/23, SR4.2/24.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: How to consolidate values in cells in order and remove duplicate?

    Hi London,

    I missed that - I'll work again on it tomorrow - and, thanks for the rep!

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: How to consolidate values in cells in order and remove duplicate?

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to consolidate values in cells in order and remove duplicate?

    Thanks jindon. It's work.

    How about if the format of cell A is changed to SR4.2/22-24?
    (i.e. both SR4.2/22-SR4.2/24 and SR4.2/22-24 can work at the same VBA)

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: How to consolidate values in cells in order and remove duplicate?

    Upload a workbook with all possible combination data and the result you want.

  9. #9
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to consolidate values in cells in order and remove duplicate?

    How to consolidate values in cells with different format as attached?
    Attached Files Attached Files
    Last edited by london7871; 03-27-2016 at 09:27 AM. Reason: Enclosed with excel file for easy reference

+ 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] How to sum duplicate values then remove the duplicate rows?
    By terry3218 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-12-2015, 02:38 AM
  2. [SOLVED] Trying to Remove Duplicate Values of Last Name List
    By sonicexcel in forum Excel General
    Replies: 3
    Last Post: 04-24-2014, 11:01 PM
  3. Remove Alphanumeric cells and consolidate
    By s_anr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-28-2013, 03:13 PM
  4. Sorting in descending order and show duplicate values
    By cceze in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-19-2012, 09:33 AM
  5. [SOLVED] macro to remove and consolidate duplicate data
    By ad9051 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2012, 09:50 PM
  6. Excel 2007 : Remove Duplicate Values from top 5
    By loknath in forum Excel General
    Replies: 1
    Last Post: 11-08-2011, 09:46 AM
  7. Replies: 2
    Last Post: 12-16-2005, 01:50 PM

Tags for this Thread

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