ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sort cells with same text descending (https://www.excelbanter.com/excel-discussion-misc-queries/63542-sort-cells-same-text-descending.html)

T-DHM

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


Jeroen

Sort cells with same text descending
 
I do not know whether I do understand your problem correctly, but would it
solve your problem when sorting column A ascending and column B descending....
--
Jeroen van Nieuwkerk




"T-DHM" wrote:


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




All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com