LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
EaglesNest
 
Posts: n/a
Default Showing Duplicate Rows

Hi All,

I have seen the question with that same title however that is not exactly
"showing" duplicates. It is more showing unique (not duplicate) I would
like to truly show the duplicates.

For instance there are several duplicate product numbers that are in my
sheet and I want to display all the duplicates so that I can make corrections.

IE:
Item number
31323
31324
31325
31326
31326
31327
31328
31328
31329
31330
31331

How can I filter so that excel will only show those rows that have duplicate
Item numbers?

Thanks
Eagle
 
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 duplicate rows then deleting them SSHO_99 Excel Worksheet Functions 4 May 4th 07 11:17 AM
How do I move rows showing a specific field to other worksheets/. jmp Excel Discussion (Misc queries) 1 March 4th 05 05:42 AM
How to delete duplicate rows in Excel 2000? PAL@Emory Excel Discussion (Misc queries) 1 January 28th 05 03:08 PM
Showing Duplicate rows in excel Jagz Excel Discussion (Misc queries) 3 January 1st 05 10:57 AM
Duplicate Rows TO Excel Worksheet Functions 2 November 12th 04 06:55 PM


All times are GMT +1. The time now is 08:51 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"