This worked exactly how I wanted.
Thank you!
Sarah

"Norman Jones" wrote:

Hi Sarah,

If you need to automate this, turn on the
macro recorder and perform the necessary
operations manually. This will provide you
with code which may be edited to afford
more generic application.

If you experience problems in editing the
recorder code, post back with the
problematic code.



---
Regards.
Norman

"Sarah_Lund" wrote in message
...
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