List unique values

[Yamaha Rider]

I have 254 rows of information. One column in the rows are the cities the address is located in.

Starting in row 256 in the column with the cities I want to list all the unique cities.
So Row 256 would say - Atlanta,
257- Birmingham,etc, etc
until all the unique cities are listed.

Is there an easy way to do this?

[zbor]

Here, try this:

=LOOKUP(REPT("Z",255),CHOOSE({1,2},"",INDEX($A$2:$A$254,MATCH(TRUE,INDEX(ISNA(MATCH($A$2:$A$254, $A$255:$A255,0)),0),0))))

[scottylad2]

Not often I get to bting out this old favourite, the first proper array function I used and it needs entered with Ctrl + Shift + Enter

I'm feeling quite nostalgic now

[Yamaha Rider]

You Guys rock! Thank you.