Help Creating Formula to Summarize Items in Spreadsheet

[mgarcia]

Hello,

I am drawing a blank on what I need to do here. I have a large list of data I will be pulling weekly. The list shows me various info, but specifically to what I am asking it has a trailer number column and an item column. I will get a list of the trailers each week that are on this list. I want a formula I can put into a cell that will read the list and tell me all the different items on each trailer. Attached is a file with some generic data to give you an idea of what I am looking for.

Thanks in advance for your help on this!
Mario

[brant.wheeler]

I don't recommend doing this with formulas as you will either end up with long, messy formulas or you will make your spreadsheet messy from a multi-step process. I recommend doing this using macros. I've attached a workbook with the macro fully functional (just press the shiny blue button). If you'd rather insert the code yourself, just paste the code from below.

Please Login or Register  to view this content.