sort duplicates in string

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

Have a string of values in column C (with header).
Need to examine string and sort all duplicated numbers to the top of
string, space inbetween the duplicates and the remaining numbers that
have only been found once.

If it matters, all numbers are 12 digits long.

Thanx
 
Note: Data is in C & D. Numbes in C in which is the duplicate
criteria, but needs to sort including column D.
 
Can you post a few examples of what your data looks like and how you
would like it to end up?

Do you have anything else in columns A and B, or in any other columns,
and if so do you want this data to remain with the numbers when
sorted? Do you want the duplicates to be listed once only at the top
of the list? Is there any particular order that you want them in?

So many questions - a posted example would answer them.

Pete
 
Back
Top