Results 1 to 10 of 10

How to merge a numbers from 3 cells, eliminate repetitive numbers, and sort such numbers?

Threaded View

david gonzalez How to merge a numbers from... 10-21-2012, 03:25 PM
FDibbins Re: How to merge a numbers ... 10-21-2012, 03:41 PM
david gonzalez Re: How to merge a numbers ... 10-21-2012, 05:29 PM
mrice Re: How to merge a numbers ... 10-22-2012, 02:04 AM
mikerickson Re: How to merge a numbers ... 10-22-2012, 03:36 AM
david gonzalez Re: How to merge a numbers ... 10-22-2012, 11:59 AM
david gonzalez Re: How to merge a numbers ... 10-22-2012, 11:37 AM
mrice Re: How to merge a numbers ... 10-21-2012, 03:42 PM
FDibbins Re: How to merge a numbers ... 10-21-2012, 06:14 PM
jindon Re: How to merge a numbers ... 10-21-2012, 07:13 PM
  1. #1
    Forum Contributor
    Join Date
    10-21-2012
    Location
    miami, florida usa
    MS-Off Ver
    Excel 2007
    Posts
    260

    Unhappy How to merge a numbers from 3 cells, eliminate repetitive numbers, and sort such numbers?

    Hi, again, this is david..




    The problem is that i pasted in 3 cells a 3 set of numbers,
    -.each cell have a not repeated numbers
    AND
    -.Some numbers appear 1 time with in the 3 cells
    BUT
    -.some numbers might will be repeated with in the 3 cells

    e.g :

    Cell F8-> 08-31-25-15-27-29-36-14-17-23
    Cell F9-> 21-22-23-24-25-26-27-28-29-30
    Cell F10-> 04-03-02-01-31-32-33-34-35-36
    --------------------------------------------
    Cell F11->


    i need to find a formula or macro to perform the follow :

    1-.Merge The 3 sets of numbers from cell F8, F9, and F10 and Copy in "Cell F11"
    2-.Sort the 3 sets of Numbers from Low to High
    3-.Show each numbers just once In Cell F11 (no repeated numbers)

    e.g


    Cell F8-->08-31-25-15-27-29-36-14-17-23 <- no sorted, each number appear 1 time in each cell
    Cell F9-->21-22-23-24-25-26-27-28-29-30 <-some #s appear repeated with in the 3 cell e.g # 23, 25, 27 and 31 appear twice.
    Cell F10->04-03-02-01-31-32-33-34-35-36
    --------------------------------------------
    Cell F11->01-02-03-04-08-14-15-17-21-22-23-24-25-26-27-28-29-30-31-32-33-34-35-36 <-- here in cell F11 the 3 cell should
    appear merged, each number should appear 1 time and sorted..





    any help, recommendation on how to do'it is appreciated


    Thank you very much !!




    Best Regards

    David
    Last edited by david gonzalez; 10-21-2012 at 03:29 PM.

Thread Information

Users Browsing this Thread

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

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