ChrisCione
Board Regular
- Joined
- Aug 27, 2008
- Messages
- 92
- Office Version
- 365
- Platform
- Windows
A system we use generates a report which looks like the sample data shown below. Note that names are repeated at least once (and often more than once). The "key" column is the confirmation indicator of Y or N (yes or no). The goal is to eliminate all duplicates under the following conditions: 1) If a person has confirmed (noted by a "Y") that information would only appear once on the report. If a person has NOT confirmed (noted by an "N"), that information would also only appear once. All we need to know is if a person confirmed or not. I've read other threads in the forum, and I'm assuming this will require code, which I have no experience in writing.
Sample data:
The desired result:
Sample data:
First Name | Last Name | Confirmation |
Mickey | Mouse | Y |
Mickey | Mouse | N |
Minnie | Mouse | N |
Minnie | Mouse | N |
Goofy | Dog | N |
Goofy | Dog | N |
Goofy | Dog | N |
Goofy | Dog | N |
Daffy | Duck | Y |
Daffy | Duck | Y |
Daffy | Duck | N |
Daffy | Duck | N |
The desired result:
First Name | Last Name | Confirmation |
Mickey | Mouse | Y |
Minnie | Mouse | N |
Goofy | Dog | N |
Daffy | Duck | Y |