This is a complex thing to explain but I am sure the genius ones grasp the idea.
I have 3 columns with 200 Rows, ColumnA has Book Names, ColumnB has Author Names and ColumnC has Prices.
There are 200 books but relate to one of 5 Authors. (Auth1, Auth2, Auth3, Auth4 and Auth5).
Prices range from $30 to $150.
What I need is EVERY POSSIBLE combination of 5 unique books from above 200 books that have total price between $350 and $450. Also Auth1 can't repeat more than once, Auth2 can't repeat more than twice and Auth5 should always be included.
Makes sense?
Kindly help
Bookmarks