Pulling Unique Data from a List

If I have a list of cities and I only want to return each city once, is there a formula I can use? For example, say I have a list like this:

Atlanta
Austin
Austin
Austin
Bakersfield
Baltimore
Baltimore
Baltimore
Boston
Boston
Boston
Chicago
Chicago

Is there a formula that will only pull Atlanta, Austin, Bakersfield, etc and list them down the rows like that? I would then do a sumif to get the numerical data I need. Is this possible?


Thanks.

Put a header at the top of the data with different formatting, select the range, do Data > Advanced Filter, and select Unique records only. Then copy the data someplace else, and duplicates will be gone.

Or, you can start someplace else, then do the same thing, and reference the data source back to the orginal range.