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