TYIA -
I'm working on a duplicate transaction analysis. I want to create a field where each duplicate "group" has a unique number. Any ideas?
Example of what I'm hoping for:
RecNo Vendor Date Amount **Group Key**
1 XYZ 4/20 $20 1
2 XYZ 4/20 $20 1
3 LMN 4/19 $35 2
4 LMN 4/19 $35 2
mh2006
Offline
Last seen: 2 years 11 months ago
Joined: 04/20/2021 - 11:36