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 10 12 14 15 16 17 18 19 21 24 25 30 31 32 35
363820 8.99 19 19 9.99 9.99 9.99 9.99 8.99 8.99 8.99 8.99 8.99
363846 8.99 8.99 19 19 9.99 9.99 9.99 9.99 8.99 8.99 8.99 8.99 8.99 8.99 8.99
369918 39 39 19.99 19.99 19.99 19.99 19.99 19.99 19.99
370049 36.99 36.99 24.99 36.99 49 36.99 36.99 36.99 36.99
370148 59 59 55 59 59 59 59 59 59 59 59 59 59 59 59


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