Here's one approach...

With the Col_B sorted list beginning in B10
and B10 as the column heading (eg name)

A1: DupeTest
A2: =OR(B11=B10,B11=B12)

Select from B10 down through the last data cell of Col_B

From the Excel Main Menu:
<data<filter<advanced filter
List Range: (already selected)
Criteria Range: $A$1:$A$2
Click [OK]

Only the contiguous duplicate values will be displayed.

Is that something you can work with?
Post back if you have more questions.
-------------------

Regards,

Ron
Microsoft MVP - Excel

"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