sort column by the strike-through values

[William Poh Ben]

Hi EXCEL expert,

How do I sort, say, column A of values to have the strike-throug
values come first, then follow by values without the strike-through ?

without the VBA code, I have to sort my data by other tedious wa
everyday at work.
Appreciate anyone who can help me with the VBA code.
Many thanks in advance

 

[Jason Morin]

There is another method besides VBA if you wanna give it a
shot.

1. Define a name (press Ctrl+F3).
2. Call it "strike" (no quotes) and in the "Refers to" box
put:
=GET.CELL(23,OFFSET(INDIRECT("rc",FALSE),,-1))
3. In the column to the right of your data (col. B in this
case), put the formula:
=strike
and fill down the column.
4. Now sort on this column.

Two notes: The first character must have a strike through
for this to work. Secondly, if you're working with an
older version than XL2002, make sure you read this:

http://makeashorterlink.com/?D4EC32596

HTH
Jason
Atlanta, GA