| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find duplicate entries and delete them?
I have a worksheet that I have containing old prices and new sorted out by
part numbers so that both old and new are listed to roughly compare the price differences. some are dups some are new products. I would like to compare part #'s and when it finds a dup, delete that entire row, or if that is not possible copy the first dup to another sheet along with ones that have no dup. I have read about macros and filter but can not get either to work. I'm sure it is operator error and not knowing what I am doing. I have 23,000 rows of data to sift through. I did it manually last time on the 12,000 rows. even if I had to hunt the 100 or so new entries that would be ok cause I have new ones colored in red. I hope I have explained this well enough.... here is what the layout looks like, just longer. thanks. the slashes are to show separation of columns, they play no role. A B C D E F G H part # / description / blank column / qty / for / blank column / retail / dealer 123 part description 2.00 1.50 123 part description 3.00 2.50 124 part description 5.00 3.50 124 part description 6.00 5.50 125 part description 7.00 5.50 |
|
#2
|
|||
|
|||
|
Hi,
Check out this post for an example and methods on how to do this: http://www.mrexcel.com/board2/viewto...759&highlight= "Agnitoood" wrote: I have a worksheet that I have containing old prices and new sorted out by part numbers so that both old and new are listed to roughly compare the price differences. some are dups some are new products. I would like to compare part #'s and when it finds a dup, delete that entire row, or if that is not possible copy the first dup to another sheet along with ones that have no dup. I have read about macros and filter but can not get either to work. I'm sure it is operator error and not knowing what I am doing. I have 23,000 rows of data to sift through. I did it manually last time on the 12,000 rows. even if I had to hunt the 100 or so new entries that would be ok cause I have new ones colored in red. I hope I have explained this well enough.... here is what the layout looks like, just longer. thanks. the slashes are to show separation of columns, they play no role. A B C D E F G H part # / description / blank column / qty / for / blank column / retail / dealer 123 part description 2.00 1.50 123 part description 3.00 2.50 124 part description 5.00 3.50 124 part description 6.00 5.50 125 part description 7.00 5.50 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete some words in autocomplete shortcut menu? | Excel Worksheet Functions | |||
| I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
| How do I delete duplicate entries? | Excel Worksheet Functions | |||
| Add numbers for duplicate entries then delete | Excel Worksheet Functions | |||
Linear Mode
