Hi everyone.
I need some help with a formula which is related a previous thread (see link below).
http://www.excelforum.com/excel-gene...-data-set.html
I need a formula which counts the unique number of orders when two items are bought together. The formulas in the thread attached double counts some orders if an order contains more of the same item (hope that makes sense!).
So in my attached example, item F & A are bought together in 4 separate transactions, and i need a formula to calculate that.
Hope someone can help.
Thanks
Mike
Bookmarks