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.