how to make duplicate entries blank

[woulfer]

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]

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

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

 

[woulfer]

Perfect!!! Thanks!!!
and that's a great resource you have there. I can see me bookmarking that
site.

 

[CLR]

ASAP Utilities, an Excel Add-in, has a feature that will delete or hide
duplicate rows......
......it's available free at www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it helped.