Good morning everyone!

I have an array in VBA, Ary1 (1 to 30, 1 to 1). It contains a list of names, some of which repeat multiple times. I want to take this list and only using VBA, and not entering the list into the spreadsheet, I want to eliminate all duplicate values from the array. So if there were say 10 original names in that list that only those would be left in the array (It can also be a new array if that is easier, I just need an array with only the original names).

I have attached a spreadsheet that shows what I want to do. In column A I have the list of names, column B has the list of names with all the duplicates eliminated and replaced with blanks, and column C has only the original names. I want to avoid using a spreadsheet for this if possible. Please let me know if you have any ideas or suggestions. Thanks so much.

Example.xls