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

if you are dealing with that many numbers, and want them sorted and have no duplicates, it would be far easier to work with if each number was entered into its own cell

Cell F8-->08-31-25-15-27-29-36-14-17-23
shoud be
f8 08
g8 31
h8 25
etc

Try this user defined function

Please Login or Register  to view this content.

Open the VBA editor by hitting Alt F11.
Insert a new module with Insert - Module
Paste in the above function
Go back to the sheet by hitting Alt F11.

In F11, enter = =GetSortedUniques(F8:F10)

Remember to save the workbook as a macro enabled workbook .xlsm

ok then i will leave you in martin's very capable hands

Sorry - one too many equals signs.

Just enter like a normal formula

=GetSortedUniques(F8:F10)

Here is a quick sort based approach. The UDF can be used in the formula

=SortDelimitedString(F8&"-"&F9&"-"&F10, "-")

Please Login or Register  to view this content.