Excel help needed p...
 

Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop

[Closed] Excel help needed please 🙂

2 Posts
2 Users
0 Reactions
49 Views
Posts: 0
Free Member
Topic starter
 

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 5:53 pm
Posts: 0
Full 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 5:59 pm
Posts: 0
Free Member
Topic starter
 

Thank you Geoff 🙂 That's it 🙂


 
Posted : 26/01/2015 6:06 pm