Most databases have a feature that allows you to hide duplicates in reports
(see below). Is there a way to do this in Excel?

STATE CITY ZIP CODE
NC Charlotte 28277
(hidden) (hidden) 28273
(hidden) (hidden) 28274
(hidden) Raleigh 28456
(hidden) (hidden) 28678
SC Columbia 29063



--
FBOL