| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete rows with duplicate values
Hi Team!
I have a spreadsheet with three colums of data. The first column contains records which have occasional phone number duplication- see blelow: (555) 000-0000 DataA1 ValueA1 (555) 000-0000 DataA2 ValueA2 (555) 555-9770 DataA3 ValueA3 (555) 555-4464 DataA4 ValueA4 (555) 555-4464 DataA5 ValueA5 (555) 555-4720 DataA6 ValueA6 (555) 555-8823 DataA7 ValueA7 (555) 555-3834 DataA8 ValueA8 (555) 555-4125 DataA9 ValueA9 What I need to do is (somehwhat) automate the process of filtering or deleting out all rows which have duplicate data in the first column, but not second or third columns. I'm sure it's been done...I tried the Excel out-of-the-box help suggestions and I've had no real luck. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can anyone tell me how to hide rows that have 0 values and text. | Charts and Charting in Excel | |||
| How do I delete rows with negative values all at once i.e. 47,000. | Excel Worksheet Functions | |||
| How do I delete duplicate rows in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
Threaded Mode
