This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I defined a table of all unique items (individually) and assigned a score to each, with the first being assigned a 1, the second a 2, the third a 4, etc - such that each successive score is twice that of the prior. In doing so, you can add the score for each transaction. If any two have the same score, then they must have the same combination of goods.
Only problem, I suppose, is that the score can get large very quickly and so could cause large field sizes (and a consequent performance drag). No problem with just 16 items sold though.
Process: - Set table of scores per item sold (see picture below) - Transposed input table (Key Field; Transaction number) - Find/Replace to join tables and add score to items - Added scores - Determine unique entries based on Score - Count records of unique scores