Hi all,
I was wondering can anyone help with my problem: To list typos / different "Name" rows, for the same Customer Number (duplicate Customer Numbers)?.
Just like my example attached, I want to create a field "Name Diff" - to detail where there are different Name instances.
As you can see from my data, there are different Names (because of typos or married name), for the same Customer Numbers.
(consider that there could be more than one Name difference, for that same Customer).
So:
- If the Name rows are not matching for a Customer - I want the value for that difference captured on that same row, otherwise 0.
- If the Name rows are matching for a Customer - I want these to be a Null value.
- If I have just one row for a Customer (just one Customer Number) I want these also to be a Null value.
Thanks for any help on a formula for this.
Bookmarks