Hello,

I'm working on a new macro that I need to group specific unique characters in column A together and then subtotal them. I'm not sure if this is the best way to do it but I was trying to use conditional formatting to highlight the characters that I need and then sort by cell color and cell values to bring them to the top and then sort alphabetically. When I try to record it to a macro it tells me that it can't identify a header row and ends up not sorting it at all and just subtotals. My data looks something like what I have below.


ya
ya
yl
yl
ya
ya
zp
zp
yb
yb
ya
ya


Basically I need it to look like this

ya
ya
ya
ya
ya
ya
yl
yl
yb
yb
zp
zp

I need everything with a ya and yl brought to the top and sorted alphabetically and everything else just sorted alphabetically.

Thanks