Hide Duplicates

F

FBOL

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
 
J

JLatham

Not like you are thinking, sorry. You could use Conditional Formatting (menu
Format | Conditional Formatting
on cells starting at the second entry (after you get them sorted).
Choose all cells in a column starting at the 2nd row down to the last entry
and then use Format | Conditional Formatting
and then leave "Cell Value Is" set to that entry, choose "equal to" in the
next entry area and finally type =A1 in the last section; where A1 is the
address of the cell above the first cell you have selected. Then click the
[Format] button and the [Font] tab and set the font color to the same as the
background color (most likely white) and then click the OK button. Repeat
for the city column also.
 
T

Tom Hutchins

If you created a pivot table from your data, with State, City, & Zip Code as
row fields, they would be presented as in your example.

Hope this helps,

Hutch
 
Top