I have a workbook set-up like stID and Name, and I am trying to write a formula that will concat all the assocated values in stID in column C and seperate by a comma so the result looks like this
stID Name Concat
1 Blue Blue, Blue
1 Blue Blue, Blue
2 Green Green
3 Red Red, Red
3 Red Red, Red
I have this formula, but when I input it and hit ctrl+enter it just writes the formula in the cell. 2 questions at hand, 1) Why does this only write the formula in the cell, and 2) Will this function return the data in my desired output?
Please Login or Register to view this content.
Bookmarks