If I had a column of say zip codes, lets say thousands, and I have a lot of repeats. Is there a built in function in Excel that lets me find all the distinct zip codes and then outputs it into an array or string? I am pretty sure I can think of a way of doing this by just using VBA, but I was just wondering if there was some built in stuff to make it simplier.