| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
mark duplicate entries
I have multiple rows of data with eight columns (A1:H1). I would like to be
able to find which rows are duplicated in column A, D, E and G. I know I can sort these by and separate any data that doesn't match but I would like to work with something a little more quicker. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
mark duplicate entries
In other words:
A10 contains 12345 D10 contains 11/3/2007 E10 contains xyz G10 contains abc this is duplicated in A801 contains 12345 D801 contains 11/3/2007 E801 contains xyz G801 contains abc "Bob" wrote: I have multiple rows of data with eight columns (A1:H1). I would like to be able to find which rows are duplicated in column A, D, E and G. I know I can sort these by and separate any data that doesn't match but I would like to work with something a little more quicker. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
mark duplicate entries
=SUMPRODUCT(($A$10:$A$1000=A10)*($D$10:$D$1000=D10 )*($E$10:$E$1000=E10)*($G$10:$G$1000=G10))1
copy down as far as needed TRUE for duplicate FALSE for not duplicate "Bob" wrote: In other words: A10 contains 12345 D10 contains 11/3/2007 E10 contains xyz G10 contains abc this is duplicated in A801 contains 12345 D801 contains 11/3/2007 E801 contains xyz G801 contains abc "Bob" wrote: I have multiple rows of data with eight columns (A1:H1). I would like to be able to find which rows are duplicated in column A, D, E and G. I know I can sort these by and separate any data that doesn't match but I would like to work with something a little more quicker. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
mark duplicate entries
Beautiful.
Thank you. "Teethless mama" wrote: =SUMPRODUCT(($A$10:$A$1000=A10)*($D$10:$D$1000=D10 )*($E$10:$E$1000=E10)*($G$10:$G$1000=G10))1 copy down as far as needed TRUE for duplicate FALSE for not duplicate "Bob" wrote: In other words: A10 contains 12345 D10 contains 11/3/2007 E10 contains xyz G10 contains abc this is duplicated in A801 contains 12345 D801 contains 11/3/2007 E801 contains xyz G801 contains abc "Bob" wrote: I have multiple rows of data with eight columns (A1:H1). I would like to be able to find which rows are duplicated in column A, D, E and G. I know I can sort these by and separate any data that doesn't match but I would like to work with something a little more quicker. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - need to mark, not remove, duplicate records. | Excel Discussion (Misc queries) | |||
| Can Excel mark or identify duplicate cells in a range? | Excel Discussion (Misc queries) | |||
| Can Excel mark or identify duplicate cells in a range? | Excel Discussion (Misc queries) | |||
| Can Excel mark or identify duplicate cells in a range? | Excel Discussion (Misc queries) | |||
| How can I find and mark double entries in a customer database? | Excel Worksheet Functions | |||
Linear Mode
