Excel help needed p...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] Excel help needed please 🙂

2 Posts
2 Users
0 Reactions
46 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

6 DAYS LEFT
We are currently at 95% of our target!