J
JMALTO
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
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