sort duplicates in string

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
 
J

J.W. Aldridge

Note: Data is in C & D. Numbes in C in which is the duplicate
criteria, but needs to sort including column D.
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top