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.