Search unique value dependent on different column

[rajsingh]

First time posting..

I have a large data set with three columns: Date purchased, Item, and Transaction id.

The transaction id can have multiple items for the same transaction id.

I want to search how many times different item combinations repeat for each transaction id.

I.e. I want to count how many times someone would order Chicken and Grain bowl together based on different transaction ids

item	transactionid
Salad	7cb3b0b6-ed6d-4d13-bff4-de990c0f2bc2
lamb_sliders	7cb3b0b6-ed6d-4d13-bff4-de990c0f2bc2
chips	7cb3b0b6-ed6d-4d13-bff4-de990c0f2bc2
Greens&Grains	7aef0a2c-9fde-477d-9992-ab78387dba92
Chicken	7aef0a2c-9fde-477d-9992-ab78387dba92
Salad	e2c99877-4c19-427f-a8e5-d81d000a05d2
braised_lamb	e2c99877-4c19-427f-a8e5-d81d000a05d2
cookie	e2c99877-4c19-427f-a8e5-d81d000a05d2

<tbody>
</tbody>

Hope that explanation made sense.

 

[hiker95]

rajsingh,

Welcome to the MrExcel forum.


We can not tell where your raw data is located, sheet name(s), cells, cell formatting, cell formulae, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, cell formulae, rows, columns.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729

 

[rajsingh]

Sorry. I have attached a screenshot, hopefully that provides more clarity.

 

[rajsingh]

Ignore the attempt to load a photo.

Column A = Date
Column B = Item
Column C = Transaction ID

I want to find out how many times multiple "Items" combinations occur for each transaction ID.

I.e. All the food items are in the same column and there are multiple base items (Bowls, Salads, etc) and multiple protein items (Chicken, Beef, etc.). I am trying to find out how many times a Bowl and Chicken are ordered by someone in the same transaction id.

 

[hiker95]

Ignore the attempt to load a photo.

Column A = Date
Column B = Item
Column C = Transaction ID

I want to find out how many times multiple "Items" combinations occur for each transaction ID.

I.e. All the food items are in the same column and there are multiple base items (Bowls, Salads, etc) and multiple protein items (Chicken, Beef, etc.). I am trying to find out how many times a Bowl and Chicken are ordered by someone in the same transaction id.

rajsingh,

We can not copy your png/photo into a workbook/worksheet.


If you are not able to provide screenshots, then:

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com