Formula to Organize Combined Values [11111/111]

Hello,
I have a formula that scans one column searching for different numbers and it list them in order without listing the same value twice. Unfortunately the formula doesn’t work with number combos I have in certain cells, so I need a new formula that works with numbers that are formatted like this [11111/111].

I have an example of what I’m looking for below and a spreadsheet with an example is attached for a better understanding.

Example:
Column B: Numbers
12323/212
12323/211
12532/321
12532/322
12532/321
12532/121
31222/111
31222/121
31222/111
31222/113
11222/211
11222/221
11222/111
11522/321
11522/321

Column D: Formula Should Equal (Listed in order without repeats)
11222/111
11222/211
11222/221
11522/321
12323/211
12323/212
12532/121
12532/321
12532/322
31222/111
31222/113
31222/121



Thank you in advance for any and all help.

Copy col B to a convenient column, select the column, Data > Remove Duplicates, then sort:

	D
1	Combo of Combos (5 lines)
2	11135/223
3	11222/111
4	11222/211
5	11222/221
6	11225/223
7	11253/232
8	11351/232
9	11455/232
10	11522/321
11	11533/222
12	12323/211
13	12323/212
14	12345/223
15	12532/121
16	12532/321
17	12532/322
18	16555/113
19	27444/133
20	31222/111
21	31222/113
22	31222/121

Or you can use this formula in C2 and copy down

=INDEX($B$2:$B$41,MATCH(0,INDEX(COUNTIF($C$1:C1,$B$2:$B$41),,),))

You're welcome and thank you for your feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

The formula I provided is to extract unique values. I am not sure how it can be organized since these vales are text and not numbers.

hi there. did you try shg's method? that would work fast. you can even record into a macro if you want to save the steps. go to View -> Macros -> Record Macro. give it a name & save in ThisWorkbook.
1. Select the entire Column B.
2. Copy
3. Select the entire Column D
4. Paste
5. go to Data -> Remove Duplicates -> OK
6. go to Data -> Sort -> OK
7. go to View -> Macros -> Stop Recording. you are done

to play it, go to View -> Macros (selecting the upper portion of the icon brings you to view macros straight. selecting lower part with the arrow would need you to select View Macros). select your macro & play

Please find attached vba macro solution that works extremely fast. Just press a button and it's done!