Creating Combinations

[michaelp]

Good Afternoon,

I have been asked to creat a spreadsheet that show the number of people
that purches a set of itmes. the problem is that the set contains 10
items and they and be purched in any number of ways eg only one item or
the first and third item or all 10 and so on.

I have created a table of all of the possable combinations (1025) og
them and then concatenated the pruches types to link to the buyers
name
eg tom 1,2,3,-,5,6,7,-,-,10 so Tom purched item 1 item 2 Item 3 56710
ect

The number of customers is arount 45,000 and thus my spead sheet is now
20meg in size with all the lookup formulars.

is there a simply way that???


thank you

 

[Roger Govier]

Hi Michael

From what you say, you are only trying to find out if a customer bought any
one or more items from the range of 10.
If that is the case, then maybe a simple Match would suffice
=IF(ISNUMBER(MATCH(A1,D1110,0)),"yes","no")

where A1 holds the item number bought and D110 holds the list of 10 items
you are interested in.

Regards

Roger Govier