return multiple values in single cell

Respected,

My scenario is as follows:

Lets say I have 5 criteria mentioned in columns ( C,D,E,F,G)

I have site names provided in column A

I have product ID list for each site in column B 

EXAMPLE:

  A B C D E F G      : COLUMNS ( B = PRODUCT ID)

SITE1 1 Y N Y N N : COLUMNS ( C, D, E, F, G ,… = CRITERIA )

SITE1 2 N N Y N Y : COLUMNS ( A = SITE NAMES) 

SITE1 3 Y Y Y N Y : COLUMNS (A = each has 40-100 product ranges)

SITE2 1 N N N Y N : Y = YES

SITE2 2 Y Y Y Y Y : N = NO

SITE2 3 N Y Y Y Y

SITE3 1 Y Y N N N

SITE3 2 Y N Y N N


I HAVE TO RETURN, ALL THE PRODUCT ID’S FOR THAT RESPECTIVE SITE WHICH MATCH TO ANY SET OF CRITERIAS I WISH TO APPLY. ( combinations of all ,or else selective criterias)

ALSO, I WANT THEM IN A SINGLE CELL WITH A DELIMITER( , : )

without using vba, is what i would prefer, but, eventually i need this problem solved. kindly do neeful.

thankyou for your support. #excelgeek

 

 

By: Anil

Leave a Reply

Your email address will not be published. Required fields are marked *