0

Hi, let say that i have this excel file that contains column of account number and the name of the customer. And I want to extract any of the data that have duplicate. And the script should be able to get the duplicate only if the both of the account number and the name of the person have been duplicated. If let say only acocunt number is duplicated, then it is not considered duplicate. Please refer the screenshot below :

duplicate

So, how suppose i do this? thanks.

2
Contributors
2
Replies
3
Views
4 Years
Discussion Span
Last Post by replic
0

I am sorry. Its actually have three column, which is account number, customer name and also the amount pay by cutomer. So the program will only assume the line is duplicate if all of these three column are the same.

Please refer to the sample below :

duplicate3

Thanks :)

0

It looks like you just need someone to write a script for you. Otherwise you would have presented your attempt to solve this problem. IIRC daniweb is not here to do your homework or normal work for you.
In other words: Present some code or go pay someone to do this for you.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.