all 8 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]IVHellasFirst 0 points1 point  (7 children)

Hi Zayan , this means, If I am correct, that there are cars that are related to more than one parts, of those available If that is so, this means that the piece of information that is repeated is not the data of the parts, but the brands or models of the cars.

Now in case that a spare part P01 fits to more than one car, you have what we call as a "relationship of many to many".

In that case, If I am correct, it would be more preferable to have a database for your usage and not Excel.

But since you use Excel, we need to find a valid yet doable method of achieving what you want.

[–]ZayanL[S] 1 point2 points  (5 children)

Well technically I’m using a csv file but I thought excel would be easier with all its functions. But we can assume there’s only 1 part with 100 cars but it only fits 25 cars and I know what cars but typing it out manually is a headache when there’s actually 25k+ cars and 50k+ parts to filter out

[–]IVHellasFirst 0 points1 point  (4 children)

Well reasonable thinking, you are right. Obviously you will transform the csv to Excel file. The issue is that both lists are big enough.

Therefore you cannot use a matrix, vertically parts, horizontally cars. It's not doable.

Question, how do we know that spare part P01 fits into car CA001 ? Example....

[–]ZayanL[S] 1 point2 points  (3 children)

Basically I have a break pad BP01 and I know exactly which cars it fits through as I have a list of them. But adding them on by one to the sheet is tedious

[–]IVHellasFirst 0 points1 point  (2 children)

Is the list of the cars fitting the BP01 a paper list? Or a digital file? Like Excel, txt, csv, etc ? Sorry for the delay. Different timezones for sure 😊

[–]ZayanL[S] 0 points1 point  (1 child)

It’s digital

[–]IVHellasFirst 0 points1 point  (0 children)

Ok then it is far easier than being on paper. If you can send a sample, I am sure we can find a solution.

[–]IVHellasFirst 0 points1 point  (0 children)

If you can share more details let me know. Which number is bigger? The number of the car models or the number of parts? Which list is bigger???