Most valuable professional
  • Hot Topics

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: Thanks Edwin Mark

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

This thread is current as of May 9, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel