Most valuable professional
  • Hot Topics

Excel Extract unique values in a row excel

I am trying to extract unique values from a row in Excel and I am not sure how to do this. It should not be complicated. Unique values in a column is pretty simple. I am not sure why it is so tricky to do the same in row. This is how the data looks. I am trying to extract unique values from each row. Example for the first record I need the values 8.99, 19. 9.99 in three separate columns. Not all records have 3 unique values. Some may have more or some may have less. Any help would be appreciated. Row Label 363820 363846 369918 370049 370148

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

This thread is current as of October 29, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel