Custom Sort of Filter?

[Steve B]

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!

 

[Mike H]

Hi,

Extract the year code with

=MID(A1,10,1)

then sort the 2 columns by this newly created column which you can then
hide/delete

Mike

 

[muddan madhu]

try this

=MID(A1,10,1) u will get number or character , sort or filter using
output values.

 

[Steve B]

AWESOME! Wow great thank you, someone was going to do this manually. THANK YOU!

 

[MikeJohnB]

If your vin number is in Column A
Use a dummy sort column
in the dummy column Row 1 enter
=Mid(A1,10,1)
Copy down the full list of Vin#
You may have to reconsider for year 2010 but it is possible to suss that out
later

Substitute A for you column letter

Sort on the dummy column for year order

Hope this helps

 

[Cheers,]

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