richmcgill
Board Regular
- Joined
- Feb 4, 2019
- Messages
- 83
- Office Version
- 2016
- Platform
- Windows
I need help.
In this example, the Account number is constant. I am looking for duplicates.
I need to identify if the account number is on here more than once.
The description dates match (the words do not matter)
Gives me a result of Delete for the persons ID of AABB.
Person CCDD would be "Okay"
If there is not a match or duplicate it should read "Okay"
Make sense?
Any help is appreciated.
In this example, the Account number is constant. I am looking for duplicates.
I need to identify if the account number is on here more than once.
The description dates match (the words do not matter)
Gives me a result of Delete for the persons ID of AABB.
Person CCDD would be "Okay"
If there is not a match or duplicate it should read "Okay"
Make sense?
Any help is appreciated.
Account Number | Person | Description | Solution or Desired Results |
123456789 | AABB | Changed 05/01/24 | Delete |
123456789 | AABB | Changed 05/15/24 | Delete |
123456789 | CCDD | Corrected 05/01/24 | Okay |
123456789 | CCDD | Corrected 05/15/24 | Okay |
Last edited: