Concatenateifs

Hello I'm looking for a function that can return me a list of strings matching specific criteria s. Anyone knows how to do it? I prefer not to use vba but if we have simple code for it I'll take it

Tigeravater posted a UDF to give multiple concatenation here:

http://www.excelforum.com/tips-and-t...geravatar.html

It can also be used for conditional concatenation, as some of the examples in succeeding posts demonstrate.

Hope this helps.

Pete

Originally Posted by ZmeY

Hello I'm looking for a function that can return me a list of strings matching specific criteria s. Anyone knows how to do it?

Can you offer an example?

Perhaps something like the following:

=TRIM(IF(A1=B1," hi","") & IF(C1=D1," world", ""))

It results in "hi", "world" or "hi world". The key is the leading space before each option, using TRIM to removing the leading space.

Hello I am basically trying to pull data out of the array for specific critiria and if it finds it more then once to concantanate it Here is the example below. So for 2 it would return C,B and for 1 or 3 it would return a or d

Data Expected Output Example of Formula Output
1 a 1 Concantatnateif(E7=$A$6:$A$10,$B$6:$B$10) a
2 c 2 Concantatnateif(E8=$A$6:$A$10,$B$6:$B$10) c,b
3 d 3 Concantatnateif(E8=$A$6:$A$10,$B$6:$B$10) d
4 e
2 b

Thank you