Hello I have a problem with excel and I cannot find a solution, maybe somebody can help, if no one else can help then I have to hire the A-Team.
So I have a list of things with same codename for similar items. I used sumif function to pick out similar things and sum their quantity. Now I'd like to select out similar items product codes, which occasionally contain letters and +-/ etc marks. I don't want to sum them up, but add found product codes on different cells or into one cell as a comma separated list.
Bookmarks