Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 100
Default Identify (not delete) exact duplicates

Using Excel 2007
Im sure Ive seen a way to extract duplicates (or identify duplicates) into
a new list somewhere on a spreadsheet i.e. I want to know what duplicates
exist, not just eliminate all but one of them.

Can I do this in Excel 2007?

MUCH THANKS and ENJOY your week-end!
Gene:)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Identify (not delete) exact duplicates

See Chip Pearson's site.

http://www.cpearson.com/excel/Duplicates.aspx


Gord Dibben MS Excel MVP

On Fri, 19 Jun 2009 09:52:01 -0700, Gene
wrote:

Using Excel 2007
I’m sure I’ve seen a way to extract duplicates (or identify duplicates) into
a new list somewhere on a spreadsheet i.e. I want to know what duplicates
exist, not just eliminate all but one of them.

Can I do this in Excel 2007?

MUCH THANKS and ENJOY your week-end!
Gene:)


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 120
Default Identify (not delete) exact duplicates

I don't have version 2007 but believe that this will works
try this
assuming your data are in column A2 to A11, place this formula
in B2 and copy down

=COUNTIF($A$2:$A$11,A2:A11)1
this will return TRUE, filter for TRUE and copy the range to another place
on the sheet.
You can slao use this in conditional format to highlight the duplicates
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Gene" wrote:

Using Excel 2007
Im sure Ive seen a way to extract duplicates (or identify duplicates) into
a new list somewhere on a spreadsheet i.e. I want to know what duplicates
exist, not just eliminate all but one of them.

Can I do this in Excel 2007?

MUCH THANKS and ENJOY your week-end!
Gene:)

Reply
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
Identify Duplicates in a List BStacy Excel Discussion (Misc queries) 1 April 16th 09 07:20 PM
not exact duplicates... Tadder Excel Worksheet Functions 3 January 19th 09 06:07 PM
identify duplicates and sum corresponding values Amanda Excel Worksheet Functions 5 April 30th 07 04:45 AM
formula to identify exact point where trendline intersects data Jane Excel Worksheet Functions 5 November 14th 06 11:09 PM
identify duplicates 5thsun7thchild Excel Discussion (Misc queries) 1 September 1st 05 04:06 PM


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