Hello,
I am trying to get a macro to look in a column for all the different values and then return each value once in another column.
For example, in column B the values are B1=Item1, B2=Item3, B3=Item1, B3=Item1, B4=Item3, B5=Item2, and so on...
In column D, I would like to return all the different values only once. For example, D1=Item1, D2=Item2, D3=Item3, and so on...
If someone can help me with this I would appreciate it.
Thank you!
Bookmarks