Hi guys, got a question relating to vba. I've done some coding so know roughly what I need to do, just don't have that much experience in excel/ vb.

So, what I want to do is get all the unique values from a range of cells and print them in another range of cells, one value per cell. For example, this would be the result:
Original List Result of Macro
a a
a b
b c
c
a
I assume this would be done by putting the values into an array and then printing that array with some kind of loop (but please correct me if I'm wrong, that guess is based off other code applicaitons).

If possible it'd be great if the macro ignored cells with commas in them e.g. if the contents of a cell was "a,b" it would just skip that cell.

Thanks for any help in advance, and sorry for the newbie question!