Excel: Extract Unique Values from Single Row

Hi, I need unique values from given dynamic range (B2:F2). Concatenated values in final cell (G2) should be comma separated. I would really appreciate if someone could solve it through formula preferably. However I couldn't able to upload file here, so please use below given dropbox link to download excel file. Excel File: https://www.dropbox.com/s/y6deupms44okct3/Concatenate%20Unique%20Values.xlsx Thanks Edwin Mark

This question generated 28 answers. To proceed to the answers, click here.

This thread is current as of May 09, 2014.

For more resources for Microsoft Excel