Forum menu
Excel help needed p...
 

[Closed] Excel help needed please ๐Ÿ™‚

Posts: 0
Free Member
Topic starter
 
[#6812224]

Thank you in advance.

I've got a ton of paints for my models. I've also got a list of models and the paints needed.
How can I get it so that I can look at a particular model and what paint I need at a glance?


 
Posted : 26/01/2015 6:53 pm
Posts: 0
Free Member
 

Model in column A (repeated) paints in column B (many) then just filter the whole lot and use the drop down to choose the model.

In theory a 1 (model) to Many (paints) relationship would be better dealt with using a relational database, but I suspect that would be overkill.


 
Posted : 26/01/2015 6:59 pm
Posts: 0
Free Member
Topic starter
 

Thank you Geoff ๐Ÿ™‚ That's it ๐Ÿ™‚


 
Posted : 26/01/2015 7:06 pm