extract multiple name and do a comparison to see if claim duplicate

[jerometyl]

Looking for help here to detect staff who have claim duplicate meals or expenses on same date. 

Please kindly advise how i can build to catch the duplicates. 

[afv2688 · Accepted solution]

Hello @jerometyl ,

How about this?

Regards

[jerometyl]

Hi Sir, 

Thank your for the kind solution, but was wondering if it is possible to get it to match back to the original data so that at one glance i will be able to know the details in that row. 

Attached the sample for your kind advise. 

[afv2688]

Hello @jerometyl ,

I transformed the data to the what I got the impression were looking for.

Regards