| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Deleting All Rows for Duplicate Entries Except Those With Most Items In Row
I need to identify & delete rows of data. Most entries in Column B
appear more than one time in my list, but the other data on the rows associated with these Column B duplicates are different. I need to keep just 1 unique occurrence of each Column B entry, and the occurrence I need to keep is the one that has the most items in each row. In the example below, I need to keep Rows 1 and 5 for the 2 unique entries in Column B. I am not comfortable with programs. Is there a way to accomplish my goal with formulas? A B C D E Row 1 KEEP 123456789 4567890123 12345 23456 34567 Row 2 DELETE 123456789 4567890123 23456 34567 Row 3 DELETE 123456789 4567890123 34567 Row 4 DELETE 234567890 5678901234 45678 Row 5 KEEP 234567890 5678901234 12345 45678 Thanks! Sandi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
| Disable Adding or Deleting Rows and Columns | Excel Discussion (Misc queries) | |||
| Deleting rows containing common data | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Need help deleting Rows | Excel Discussion (Misc queries) | |||
Threaded Mode
