View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sarah_Lund Sarah_Lund is offline
external usenet poster
 
Posts: 5
Default Find and display only duplicates

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