I use BrickSet.com to easily find all sets containing a specific part e.g. http://brickset.com/sets/containing-part-374726. Is there a way on that site or any other to find all the sets containing two specific parts?
Although clunky you could consider using Microsoft Excel to do most of the work for you.
- On Brickset search for the first part
- On the top bar click CSV or (comma separated values)
- Copy the text
- Open Excel (I'm using 2010)
- Select Cell A1
- In the top right corner click the arrow bellow paste and select "Import Text Wizard..." (depending on the version this option may be in another place)
- Selected Delimited and click next
- On the following page select "Comma" click next
- Select each row that is not "SetID" and select "Do Not Import" click finish (alternatively you can manually delete the extra rows after finish)
- Repeat steps for the second part you are looking for. However Select Cell B1 instead of A1. You'll end up with two rows of SetIDs
- Finally highlight both columns of SetIDs and select "Conditional Formatting", >"Highlight Cell Rules"> "Duplicate Values"
The cells that are highlighted will be the sets that contain both parts.
From what I can tell, there is no way to cross-reference within the site itself, but it wouldn't be difficult to write a short code to do the cross-checking for you.
I'm not a programmer or web-developer, so I lack any basic coding skills, but for someone who is more able, this would be a very simple task. After you open the page that gives the list of sets containing said part (one page for each of the parts you're looking for) you can easily find all sets sharing two parts by having your browser run a Jscript that does the following:
Generates a list of all set numbers that contain said part (one list per page)
Generates a list of all set numbers that are shared in all previous lists
Let me know if that is confusing...
http://rebrickable.com has an advanced search option that allows you to search for parts within specific sets, that might be able to help you.
It also has an API that returns the sets containing a specific part: http://rebrickable.com/api/docs?fn=get_part_sets - although this does require the inclusion of a colour as well. From that you could write a simple comparison between the two results. However this probably won't scale all that well if you then want to find the number of sets containing 10 specific elements.