Hi
Please can I have some help on how to create a 2 way formula for the table attached.
I need a formula to list all the counts of 3, for example Customer 1 the result will return Oranges and Peaches
TABLE.PNG
Sorry if this hasn't attached properly.
Thanks
S
Do you want the results all listed in cell B9 seperated by a sace or comma? Or do you want the results listed in B9,C9,D9,E9
Listed please, B9,C9,D9,E9
Thanks for your help.
I have re-arranged the output to something that makes sense to me but may not be what you are looking for. I listed the customers in A11:A14 then in B11 entered this array formula (enter with Ctrl + Shift + Enter) and filled across and down. It takes the value from B9 (the value wanted results for) and applies to all customers.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
This is perfect and it works!
Thank you for your help!
Thank you for giving feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks