How can I use a VBA code on an example ?

[public]

I have the following VBA code (thanks for this code: admin - excelfox.com forum):

Please Login or Register  to view this content.

Which has the following function:

=CONCATIFS(
the rows can be concatenated;
concatenation separator;
the rows of criterion 1;the value you are looking for in criterion 1;
the rows of criterion 2;the value you are looking for in criterion 2)

Example: =CONCATIFS($C$2:$C$50,", ",$A$2:$A$50,F$1,$B$2:$B$50,$E2)

Now, I would like to use CONCATIFS (see the attached file below).
So, in this file are three columns: Motivation, Names and A + B. Since Column B is filled randomly, depending on the B values, column C will be automatically populated. In the example from the file, now in cell F2, I would like to list (separated by ";") only the content of C2, C3 and C4 cells. How can I do this?

[Kaper]

If I understand you well, you would like to use:

Please Login or Register  to view this content.

but the function do not work with "<>" as for instance COUNTIF etc.

Simple solution would be by modifying this :

Please Login or Register  to view this content.

by adding "is not empty" check:

Please Login or Register  to view this content.

See attached file. (Note that it stil do not work as expected with such parameters as ">10" etc.)