Hi, again I'm asking everyone's help to provide the formula for below problem.
Criteria: Look for values that matches on column A from cell F
Result: All the values from column B will be concatenated in 1 cell after satisfying the criteria but same values at column B must not be displayed.
See attached. Expected outputs are displayed in column G, highlighted in red.
Thanks in advance.
Bookmarks