View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMALTO JMALTO is offline
external usenet poster
 
Posts: 16
Default Concatenate with differents conditions

I need the formula to combine in cell "I 1", data from more
than 2 cells in column "A", when cells from columns "F and/or G"
MATCH data in cells from column "H", only IF column "B" is =1.
Example "I1, I2, I3, etc"

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