How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Bing Your Own Question
Bing, Programming Tutor
Category: Programming
Satisfied Customers: 5937
Experience:  Microsoft Certified Solution Developer
Type Your Programming Question Here...
Bing is online now

I'm looking for a formula to select my ltiple values of a

Customer Question

I'm looking for a formula to select my ltiple values of a table dependent on its category
JA: Is there a specific language you're coding in?
Customer: I need excel help not coding. Is this possible?
JA: Anything else you want the programmer to know before I connect you?
Customer: No
Submitted: 13 days ago.
Category: Programming
Expert:  Bing replied 13 days ago.

Hello and welcome to JustAnswer, an independent technical support website. My name is ***** ***** it’s my pleasure to be assisting you today.

Can I see a screenshot showing how the original symptom looks like from your side?

Customer: replied 13 days ago.
I have a table with 2 columns titled sku & category. I want a formula that populates a third column with three skus with a comma between from the same category. So for instance: if sku number 1 is a Drama then the formula populates third column with three other skus that are in Drama categor
Expert:  Bing replied 13 days ago.

Can you please upload the workbook for review and revision?

Customer: replied 13 days ago.
File attached (P62L4SM)
Expert:  Bing replied 13 days ago.

Thanks. Reviewing.

Customer: replied 13 days ago.
Third column should pick up 3 "skas" based on the same category
Expert:  Bing replied 13 days ago.


FYI - I am in a remote session at the moment. Back to you shortly.

Customer: replied 13 days ago.
Okay. Thanks
Expert:  Bing replied 13 days ago.

Do you mean you want to show all SKUs in one cell?

Customer: replied 13 days ago.
please, spared by a ","
Customer: replied 13 days ago.
Customer: replied 13 days ago.
Expert:  Bing replied 13 days ago.

Unfortunately, there is no such formula to aggregate all found items into one cell or columns

The only way is to use Pivot Table to retrieve them in rows, as shown below.