I have data in the following format:
Week, Orders
15, order1
15, order2
16, order3
16, order4
17, order5
17, order6
17, order7
I wish to lookup which orders are due in each week, returning the results to a single cell for each week, eg
Week, Orders
15, order1 order2
16, order3 order4
17, order5 order6 order7
I can return it to multiple cells with an array formula; do I need to continue down that path and gather those results somehow, or is there a better way of going about this?
Bookmarks