Conditional formatting

[JJ]

Hello,

In column A there are positions that have been sorted but
each position appears more than once. Using conditional
formatting I would like to hide the duplicates in column
A only as there is information in other columns that
needs to be visible.

Example;
Column A Column B
Branch Manager Branch Revenue
Branch Manager Income
Branch Manager America's & Pacific RAC
Sales Manager Utilisation
Sales Manager Revenue
Sales Manager Pre Tax Income

Result;
Column A Column B
Branch Manager Branch Revenue
Income
America's & Pacific RAC
Sales Manager Utilisation
Revenue
Pre Tax Income

Thanks

JJ

 

[Dave Peterson]

Debra Dalgleish has some nice instructions at:

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

(Use the top example in your case)

 

[Debra Dalgleish]

There are instructions for hiding duplicate entries on my web site:

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