I'll appreciate before hand if you can help me with this formula. I've
already created a macro that does the work but I'm confortable using formula
more than macros.
What I need the formula to do is to concatenate in cell "I1" data from more
than 2 cells from column "A" when cells from columns "F and/or G"
MATCH data in cells from colum "I" and with a condition IF column "B" is =
to 1. Example "I1, I2, I3, etc"

I am trying to use this formula

=StringConcat(", ",IF($F1:$F$7 OR $G1:$G$7,MATCH($H1,""),0),$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

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

I've posted one crack at this in your latest re-post
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"JMALTO" wrote:
I'll appreciate before hand if you can help me with this formula. I've
already created a macro that does the work but I'm confortable using formula
more than macros.
What I need the formula to do is to concatenate in cell "I1" data from more
than 2 cells from column "A" when cells from columns "F and/or G"
MATCH data in cells from colum "I" and with a condition IF column "B" is =
to 1. Example "I1, I2, I3, etc"

I am trying to use this formula

=StringConcat(", ",IF($F1:$F$7 OR $G1:$G$7,MATCH($H1,""),0),$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

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