Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Jeroen
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stopping pasted text deliminate across multiple cells Paul from NZ Excel Discussion (Misc queries) 3 September 8th 05 06:06 AM
Counting Occurrence of Text within Text in Cells in Range. Jeremy N. Excel Worksheet Functions 1 September 8th 05 05:16 AM
Text shown up in other cells everytime a text is entered in 1 cell bioyyy Excel Discussion (Misc queries) 1 August 26th 05 05:26 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM


All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"