This works great. Is there any way to do this with a macro so the enduser
doesn't have to do these steps each time they get an updated excel file?

Thank you,
Sarah

"Norman Jones" wrote:

Hi Sarah,

In C2, enter the following formula:

=COUNTIF($B$2:$B$11,B2)1

and drag the formula down as far as needed.

Now autofilter columns A:C of your data,
using a criterion of true for the third
column of the autofilter.

Now only data rows will be visible for
which there is a duplication of column C
data

---
Regards.
Norman


"Sarah_Lund" wrote in message
...
I need help please! I have a worksheet with multiple rows/columns of data.
I
need to look at the text in each cell in column B (which is already sorted
alphabetically) and if a cell is repeated, to display only the rows in
which
the cells in a column are duplicates.

For example below I would only want to to display the two rows that the
text
Cory is repeated.
Col A Col B
* Aaron
* Ben
* Cory
* Cory
* David
* Evan

I have not been able to figure this out on my own. Any help is greatly
appreciated.
Thank you,
Sarah