Concate results from multiple search

Hi,

Newbie here. I have gotten pretty far with the answers found in this forum...thanks. I now have a problem I can't seem to figure out. I have the following data

A B C D E F G H I J
121212 10/27/2012 14:23:45 XXXX 12345 S 1111111 12345
765473 10/27/2012 15:20:15 xxxxx 54321 D 54321
234343 10/28/2012 12:12:34 xxxxx 12345 D 55555
986766 12/28/2012 12:23 xxxxx 55555 S 2222222
656565 12/28/2012 15:54:00 xxxxx 12345 S 3333333

Column I is the result of a E1-E5 filtered with unique values only.

In Column J, I want to list all the values from column G that match the value in I and column F = "S". So the result would be:

A B C D E F G H I J
121212 10/27/2012 14:23:45 XXXX 12345 S 1111111 12345 1111111,3333333
765473 10/27/2012 15:20:15 xxxxx 54321 D 54321
234343 10/28/2012 12:12:34 xxxxx 12345 D 55555 2222222
986766 12/28/2012 12:23 xxxxx 55555 S 2222222
656565 12/28/2012 15:54:00 xxxxx 12345 S 3333333

These all need to be treated as strings. I have the following formula in J but it only gives me the first result (1111111) =CONCATENATE(INDEX(G1:G5,MATCH(I1&"S",E1:E5&F1:F5,0)))

Any help would be appreciated.

thanks for looking...see if this is OK.

test1.xls

Thanks Zbor...but when I tried your formula, I get a #NAME? error.

Thanks zbor. I am working on 2 computers and forgot to copy the VBA code. Works much better now It concatenates all the values....is is possible to check for duplicate values and if already part of the list, don't add it ? Thanks again.

Thanks zbor. You've been a great help.