mike1984
10-01-2015, 03:52 AM
Hi all,
I'm looking for a formula which will tell me the unique number of transactions where two items have been purchased together.
I have searched the forum and found this thread which is part way to getting what I am after (last post), but it does not count unique transactions.
I have seen from other threads that the 'frequency' function can be used to count unique items but I am not sure how to incorporate it into the formula.
I've attached a sample of my data and what I am looking to achieve.
Hope someone can help :thumb
Thanks
Mike
I'm looking for a formula which will tell me the unique number of transactions where two items have been purchased together.
I have searched the forum and found this thread which is part way to getting what I am after (last post), but it does not count unique transactions.
I have seen from other threads that the 'frequency' function can be used to count unique items but I am not sure how to incorporate it into the formula.
I've attached a sample of my data and what I am looking to achieve.
Hope someone can help :thumb
Thanks
Mike