Concatenating product names by category code

Hi,

I am trying to create three fields that extract and concatenate the product names of products that fall in certain categories; namely A, O and B. I tried using the OFFSET function to try and get the name of each product in each category, but I failed miserably!

I've attached a sample spreadsheet if anyone can help.

Thank you in advance!

UDF

Use in cell L2 like

=JoinCategory($B2:$K2,RIGHT(L$1,1),", ")

Then copy right + down

Please Login or Register  to view this content.

Originally Posted by jindon

UDF

Use in cell L2 like

=JoinCategory($B2:$K2,RIGHT(L$1,1),", ")

Then copy right + down

Please Login or Register  to view this content.

Wow. That worked like a dream!! Absolutely spot on.

Thank you!!