View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
T-DHM
 
Posts: n/a
Default Sort cells with same text descending


hi,

Need some help with a spreadsheet which has the following setup

aaa 111
bbb 223
ccc 345
ddd 564
ddd 123

Now what i need to do is have the highest similar text cells
descending.
i.e
ddd 123
ddd 564
aaa 111
bbb 223
ccc 345

I would like the individual rows to be shifted in this order also, not
just column A and B.
Any guidance in the right direction would help!
Thanks,
T-DHM =)


--
T-DHM
------------------------------------------------------------------------
T-DHM's Profile: http://www.excelforum.com/member.php...o&userid=30136
View this thread: http://www.excelforum.com/showthread...hreadid=498767