LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Duplicates rap43 Excel Discussion (Misc queries) 4 October 22nd 09 05:01 PM
Display all values in other cells with no duplicates Shu of AZ Excel Discussion (Misc queries) 0 November 9th 07 01:00 AM
Display a 1 for the first of duplicates noelle Excel Worksheet Functions 4 October 4th 07 03:10 PM
Duplicate value are removed, but how can i display in tx8 the amount of duplicates there are ? [email protected] Excel Programming 0 March 1st 07 10:14 AM
Find duplicates ljCharlie[_5_] Excel Programming 7 May 11th 04 12:56 PM


All times are GMT +1. The time now is 06:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"