How can I find and sort specific data within a column?

  • Thread starter bpreas - ExcelForums.com
  • Start date
B

bpreas - ExcelForums.com

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?
 
B

Bryan Hessey

Manually yes, select the column and sort ascending, then select the
items (now blocked together) and sort descending.

As an automated happening I have not much of an idea.
 
B

Bob Phillips

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" <[email protected]>
wrote in message
 
B

bpreas - ExcelForums.com

Thanks for the help!

Using multiples of the formula Bob Phillips provided I have created a
macro to complete this task.

Thanks again.
 
Top