How to choose words by criteria and display them in one cell?

**bccb** · 03-04-2013, 05:07 PM

Hello,

I would like to make a file where to fill in new words. I would like to fill in the word, definition and a group the word belongs to. Currently the name of the group is chosen from a drop-down list. I would like to have a cell where all the words that belong to a group are displayed, it is yellow in the file. There would be lots of words, so I would like to have a formula which would select the words based on the value in the C column and display the words from A, which belong to the same group. I would be grateful if anyone could help me.

**vlady** · 03-04-2013, 07:33 PM

try the concatif c/o mike

here's your sample file

Dict.xlsm

**bccb** · 03-05-2013, 04:00 AM

Thank you very much for your reply. This is just what I need, it looks perfectly on the file that you have sent me, but if I try to edit anything or add the same function, in the cell appears #Name? and it seems that there is no such function in the list of functions. What can I do so that I can use it?

**vlady** · 03-05-2013, 04:08 AM

it's a User defined function (UDF)
go to my attachment, right click on the tab..look for "view code" - it will bring you to a new window...look for the "module" there.copy the code to your workbook module.
then you have to save the file as "macro enable worksheet"