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?
i think you'd have to use that array and then concantanate the results
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
First, install the special Concatentation UDF into your sheet:
Please Login or Register to view this content.1. Open up your workbook.Now, setup your chart. Over in column C, enter your chart:
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet.
The formula to use is shown in D2 above. Enter that and copy down.Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks