Hi,

Unfortunately I'm pretty much a novice when it comes to Excel so the more complex functions of the software seem to elude me so hopefully someone here can be of help.
I have a big file of close to 5000 rows I think. It contains parts for cars but one part can fit on a range of car models. I'd like to rework the list so it will show each part number in a row with in that row one car model with a range of years that car was made. It should not sum them all up but rather display only the lowest and highest value so it shows the range.
I think the attached simplified spreadsheet will make things more clearly. car_applicationlist.xlsx
Many thanks for any help you can offer.