Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Duplicate rows
Hello I have a need to be able to do the following: Scenario: 1000 rows that contain duplicates in columns A, C, E. (there are no 1000 duplicates, but 1000 rows contain data that could be duplicates). Based on these 3 columns, I would consider it a duplicate record if al 3 columns' values are identical. However, Column E is an email addres and I want to consider this column duplicate if the domain name is th same. The excel function I created will extract the domain nam =MID(E2,FIND("@",E2)+1,FIND(".",E2)-1), which will extract the domai name to a new column (F). So, If A, C, and F are duplicate, it is duplicate record. Columns B,D,G etc do not matter. Is there a way to do this programatically? Ideally, I would like a entire list of the unique values to be placed on another sheet. Thank you Terr -- terryvanduze ----------------------------------------------------------------------- terryvanduzee's Profile: http://www.excelforum.com/member.php...fo&userid=3700 View this thread: http://www.excelforum.com/showthread.php?threadid=56728 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate rows into new rows based on row value | Excel Worksheet Functions | |||
Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
Duplicate rows Elimination- change rows accordingly | Excel Programming | |||
finding duplicate then copying macro.. | Excel Discussion (Misc queries) | |||
copying duplicate entries | Excel Programming |