| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove row duplicates
I would like to remove duplicates from a row and keep the first (row 1) data
Column A-part number Column B-desc. Column C-qyt. row 1 456789 lock washer 1 row 2 456789 lock washer 5 row 3 456789 lock washer 10 desired result 456789 lock washer 1 TY in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove row duplicates
Why not in Cell D2 (assuming it to be blank) enter:
=IF(A2<A1,"First","Repeat") and copy down. Then Auto-filter on "Repeat", and Delete ALL Then Unfilter to only First(s)... Delete Col D "SNAP TO GUIDES DON''T SNAP" wrote: I would like to remove duplicates from a row and keep the first (row 1) data Column A-part number Column B-desc. Column C-qyt. row 1 456789 lock washer 1 row 2 456789 lock washer 5 row 3 456789 lock washer 10 desired result 456789 lock washer 1 TY in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Duplicates | New Users to Excel | |||
| How to remove duplicates? | Excel Discussion (Misc queries) | |||
| Merge and remove duplicates? | Excel Worksheet Functions | |||
| how to remove duplicates ONLY within the same category | Excel Discussion (Misc queries) | |||
| Remove duplicates | Excel Discussion (Misc queries) | |||
Linear Mode
