Is "StringConcat" function a user defined function (UDF)?
Could you please post the code for this UDF?

--
R. Khoshravan
Please click "Yes" if it is helpful.


"JMALTO" wrote:

I am using a very good function called "StringConcat" where I'm comparing
cells on columns F and G, and when any cell in column H match it, then I
collect data from that very same row in column A. Example: Because data that
match in columns G1, G4 with the data on column H, then I pull data from the
corresponding rows in column A. I1=A1 and A4. Notice that also A7 match cell
H1, but I don't want it because cell B7 is not equal to 1.
So, that is what I want to add to the formula a condition that IF cells in
column B=1 then I want the corresponding data on cells in column A.
This is what I have so far.

=StringConcat(",
",IF($F$1:$F$7=H1,$A$1:$A$7,""),IF($G$1:$G$7=H1,$A $1:$A$7,""))


A B C D E F G H I
WSt USA Ch Srv Ob LHD TD TL USA
1 100 1 30 24 24 100, 103
2 101 1 33 30 100, 102, 105
3 102 1 30 33 101, 103
4 103 1 33 24 50 105
5 104 1 84 85 74
6 105 1 30 50 84
7 106 1 33 24 85

When it commes to machinning, I am the BEST