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