Hi,

I prefer creating the dummy column however, you can filter on the VIN #
column by choosing Custom choosing equal, and entering ?????????7* to find
all the 2007 vehicles.

Sorting is another problem.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Steve B" wrote:

Greetings,

I have an Excel Sheet with lists of vehicles I need to sort or filter by
Model Year. The only way to determine that in this list is by the Vehicle ID
Number (VIN) The Vin is 18 digits long, with the number or character in the
10th Position indicating the model year (ie 7=007, 8=2008, 9=2009)

Anybody have any suggestion on how to sort/filter/break these units out?

Thanks in advance as always for the great support!