Find all and only those books in 2 collections

Hi everyone,

I am trying to figure out if there is a way for me to find all the books that are in 2 or more collections exclusively. For instance, if I have books that are listed both under the 'Favorites' collection and the 'Literature' section I want to be able to see only those books. Is this possible?

I know that under the statistics page, there is a way to look at all the books under two collections, but this will include books that are not just in both but in either too (so it will include all my non-favorite literature books and my non-literature favorite books as well). All I want is a way to see all the books that are both favorites and literature. I hope that makes sense!

>1 m_z: Exporting to excel and filtering on Collections with Favorites and Literature and not two commas? (Comma is used to separate the different Collections, so two or more commas would mean three or more collections).

On Charts and Graphs page, under collections there is a section about overlaps between collections. The links lead to your catalogue filtered to only books in both of those collections

Thanks bnielsen and SandraArdnas, exactly what I was looking for!

I've duplicated some collections as tags, for exactly this reason. Tags use a logical search, AND etc.

>5 reading_fox: I have a script that downloads the export file and trims the fields a bit, so it can be used as a database. Often I let the queries return a list of Book_Id's with OR as seperator, like this:

206810728 OR 206810748 OR 206911120 OR 206911151 OR 206911162 OR 206911234 OR 206911271 OR 206947167 OR 206947207 OR 206947322

I can then copy/paste it into LT's search field and get (in this case) the 10 latest additions to my collection.