Forum Discussion
Consolidate unique values from matched cells
Hi All, The table below probably explains it best, however, I am trying to consolidate the unique values in column C against the common value in column B then populate the consolidated data into ...
Peter,
{=IF(COUNTIFS($E$3:$E$5,A3),"Direct"&IF(B3="","","/"),"")&TEXTJOIN("/",TRUE,IF(($A$3:$A$12=A3)*($B$3:$B$12<>""),$B$3:$B$12,""))}
Many thanks Detlef. Works perfectly.
Peter
