Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identify Duplicates in a List | Excel Discussion (Misc queries) | |||
not exact duplicates... | Excel Worksheet Functions | |||
identify duplicates and sum corresponding values | Excel Worksheet Functions | |||
formula to identify exact point where trendline intersects data | Excel Worksheet Functions | |||
identify duplicates | Excel Discussion (Misc queries) |