You can use Conditional Formatting to hide the duplicates. There are
instructions he

http://www.contextures.com/xlCondFor...html#Duplicate

woulfer wrote:
I want to make a column that lists "city name" to only show each name once,
then leave a each repeat of the name blank. Is there a formula for this?

Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html