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

  • Thread starter Thread starter bpreas - ExcelForums.com
  • Start date 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?
 
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.
 
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
 
Thanks for the help!

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

Thanks again.
 
Back
Top