excel - Concatenate certain cells from column based on two conditions -
i have excel worksheet of different football teams , squads, , information individual players. trying is, table, concatenate cells , place data cell on more simpler table other users see, instance, show players injured in teams. i'll explain: f_team | player | injured liverpool coutinho 0 liverpool benteke 1 liverpool sturridge 1 man u rooney 1 chelsea sterling 0 so in other table looks this f_team | players injured liverpool benteke, sturridge man u rooney so data can grouped individual teams, stuck trying concatenate properly. i have tried using vba, comes #name? , don't know why, , don't know if doing correct. function concatenateif(criteriarange range, criteriarange2 range, _ condition variant, condition2 variant, concatenaterange range, _ optional separator string = ",") variant 'update 20150414 dim xresult string on error resume next if criteriarange.count <> concat...