vin

I have list of unique VINS. I also have a list of 35 parts that belong to each VIN. I need to combine these list so that i have A VIN, then 35 parts, then ANOTHER VIN with the same 35 parts, then a 3rd VIN, etc. Seems like it should be easy . . . but stuck. A macro would be nice . . . but...

Is there a formula or conditional format you can use to extract and string from a cell where the string is always a certain number of characters. I have a spreadsheet where the cell includes the VIN for an auto but the VIN is always 17 characters long. The problem is there are other items in...

Hi, I have the data a give in the table. I need a formula to differentiate the maximum value to each names updated in column A <colgroup><col width="64" style="width: 48pt;" span="2"><tbody> User Percentage Satz 20 Satz 80 Eliy...

Happy Friday All! Below is a simple table of data that I need help with. In my real sheet Column A has over 7,000 Items. Column D (Col C is blank) has about 400. I am trying to figure out a formula that will Search column A for a match in Column D, then return the value of Column B in Column E...

I deal with VINS all the time. Example, <tbody> 3FA6P0G73HR402900. i need to parse that out and bring in position 5,6,7,8 and 10 into a new cell, preceded by "VIN". I usually just enter ="VIN"&Mid(A1,5,4)&MiD(A1,10,1), to give me VINP0G7H. (The VIN isnt always in column A . . . but it will be...

Is there anyone who can debug the macros in the attached .xlsm file. The professional can easily correct the mistake. I'm not able to do that. The process: It is a simple VIN Decoder. I load the list of VIN numbers of cars, and it shows me information about the cars. The Problem: Validate VIN...