in F34 put in

=IF(COUNTIF($E$34:E34,E34)=1,1,2)
Then drag fill that down to F38

Select E34:F38 and sort with the first key being
Column F, Ascending
second key being
Column E, Descending

--
Regards,
Tom Ogilvy


"Patty" wrote in message
...
Tom

All numbers are in different cells E34-E38.
They are only single digits from 1-6
There can be multiple repeated numbers. Like (6-6-6-5-4, 6-
5-5-5-4, 6-6-6-6-5, 1-1-2-2-2, 4-4-4-4-6), Again each of
the 5 numbers are some what random soo the possibilities
could be endless.

Thanks for your help.
Patty


-----Original Message-----
when you save you have 5 random numbers, where are they
located. Each set
of 5 in a separate cell. How are the stored in the cell -
do they include
the parentheses or is it 5 numbers like 1-5-4-6-6

are the numbers all single digit.

If you had 2-2-3-3-1-1 how would you want the
numbers sorted
1-2-3-1-2-3 ? In other words, for numbers pushed to the
bottom of the
list, how are they to be sorted or would there only ever
be one repeated
number.

--
Regards,
Tom Ogilvy



"Patty" wrote in
message
...
I have a sorting issue that I need help with, I do not
know if it is possible to do this and I have tried a ton
of different things, so I decided to see if anyone out
here has an idea.

I have 5 Random numbers (ie.(1-5-4-6-6, 5-5-5-3-6)) I
want
to put these in order from high to low (sort decending),
but if the number is displayed more than once i want to
push it to the bottom or the string to look like this
(6-5-
4-6-1, 6-5-3-5-5)???

Any ideas if this is possible?
Patty



.