VIN Number sorting
"HRassist" wrote:
With the advanced filter function I couldn't find a place to indicate the
beginning sequence I was looking for (I.E.the first 6 digits of the VIN
numbers)--- also--- Would a count function work with the sort filter?
Because-- after I have the list of VIN numbers- I will need to count how many
there are?
Thanks BJ!
"bj" wrote:
check out <data<filter either auto filter or advanced filter could
potencially do what you want
"HRassist" wrote:
I have over 12000 VIN numbers on a worksheet. What I would like to do is find
an equation that would pull all of the VIN numbers that started with a
certain sequence of numbers & Letters -
Ie all VIN numbers that begin with RVS1T3. I've tried using the V-Lookup
and I can't seem to get the equation to pull correctly.
Please help!
Thank you
|