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!

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

"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!

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

"Mike H" wrote:

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

"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!

try this

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

On Dec 4, 12:35*am, 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!

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
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"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!

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!