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[TABLE="width: 314"]
<tbody>[TR]
[TD]
item[/TD]
[TD="colspan: 2"]
transactionid[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Salad[/TD]
[TD="colspan: 4"]7cb3b0b6-ed6d-4d13-bff4-de990c0f2bc2[/TD]
[/TR]
[TR]
[TD]lamb_sliders[/TD]
[TD="colspan: 4"]7cb3b0b6-ed6d-4d13-bff4-de990c0f2bc2[/TD]
[/TR]
[TR]
[TD]chips[/TD]
[TD="colspan: 4"]7cb3b0b6-ed6d-4d13-bff4-de990c0f2bc2[/TD]
[/TR]
[TR]
[TD]Greens&Grains[/TD]
[TD="colspan: 4"]7aef0a2c-9fde-477d-9992-ab78387dba92[/TD]
[/TR]
[TR]
[TD]Chicken[/TD]
[TD="colspan: 4"]7aef0a2c-9fde-477d-9992-ab78387dba92[/TD]
[/TR]
[TR]
[TD]Salad[/TD]
[TD="colspan: 4"]e2c99877-4c19-427f-a8e5-d81d000a05d2[/TD]
[/TR]
[TR]
[TD]braised_lamb[/TD]
[TD="colspan: 4"]e2c99877-4c19-427f-a8e5-d81d000a05d2[/TD]
[/TR]
[TR]
[TD]cookie[/TD]
[TD="colspan: 4"]e2c99877-4c19-427f-a8e5-d81d000a05d2[/TD]
[/TR]
</tbody>[/TABLE]


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