I’m fairly beginner when it comes to Excel formulae, and I’ve been presented with a challenge I’m afraid is far beyond me.
Attached is a snippet example of a very large table I’m working with. The important data in the table includes Street Names (B) and Ward Numbers (F).
A snippet of a data set before operations.
In most cases, column B will have duplicate values where column F also has duplicate values. I would like to consolidate these “duplicate” rows, e.g.:
| Column B | Column F |
|---|---|
| CHAPMAN DR | 03 |
| CHAPMAN DR | 03 |
could become a single row:
| Column B | Column F |
|---|---|
| CHAPMAN DR | 03 |
HOWEVER, sometimes the duplicate values in B will be associated with multiple different values in F. If that occurs, I want to leave ALL of these rows untouched, even if there are some “matches” in a subset of them, e.g.:
| Column B | Column F |
|---|---|
| CHARLES ST | 06 |
| CHARLES ST | 06 |
| CHARLES ST | 02 |
| CHARLES ST | 02 |
would not merge ANY values; it would remain 4 separate rows!
An optimistic snippet of a data set after operations.
Is this possible?
BONUS POINTS: I would like to do some simple operations on numeric data in columns C-E while consolidating; for example, when merging the two CHAPMAN DR lines, take the min value from column D for the resultant row. This seems easier than the main question, though, so I’m not as concerned with hashing it out.
