Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I find and sort specific data within a column?
I have data in a column that always begins with a letter and ends with
a number. R1 G3 B1 etc. I need to sort all data in ascending order except anything that begins with the letter B. These must be sorted descending. Can this be done? |
#2
|
|||
|
|||
Manually yes, select the column and sort ascending, then select the B items (now blocked together) and sort descending. As an automated happening I have not much of an idea. bpreas - ExcelForums.com Wrote: I have data in a column that always begins with a letter and ends with a number. R1 G3 B1 etc. I need to sort all data in ascending order except anything that begins with the letter B. These must be sorted descending. Can this be done? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=392035 |
#3
|
|||
|
|||
Add a helper column
=IF(LEFT(A1,1)="B","ZZZZZZ",A1) copy down and sort all columns with the helper column as key. -- HTH RP (remove nothere from the email address if mailing direct) "Bryan Hessey" wrote in message news:Bryan.Hessey.1t4hyb_1122962706.8926@excelforu m-nospam.com... Manually yes, select the column and sort ascending, then select the B items (now blocked together) and sort descending. As an automated happening I have not much of an idea. bpreas - ExcelForums.com Wrote: I have data in a column that always begins with a letter and ends with a number. R1 G3 B1 etc. I need to sort all data in ascending order except anything that begins with the letter B. These must be sorted descending. Can this be done? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=392035 |
#4
|
|||
|
|||
Thanks for the help!
Using multiples of the formula Bob Phillips provided I have created a macro to complete this task. Thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort data from 1 work sheet into another | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
How to sort/update large excel db | Excel Discussion (Misc queries) | |||
data sort by highlighted or coloured cell | Excel Worksheet Functions |