We have a challenge in my office that I think needs a developer’s help to solve. I am the one managing an access control system in our office, we have noticed that whenever we pull the report from the system which comes in form of a .CSV file or excel, there are cases where multiple rows will contain an Individual’s information. This might be as a result of users flashing their IDs multiple times or malfunctioning of the system’s application sometimes.
Our Challenge is to remove these duplicates before sending it out to our HR team. We do not have a developer or programmer to do this for us. I am pleading for experienced developers here to help me develop a script that will take in the .csv of excel file and remove duplicate record for an individual. That is, whenever the script encounters two or more rows containing information for one person, it will keep the first record and delete other rows with same information until it encounters record for a different person. I have attached a sample file to clarify my need. In the attached file, we want a script that will keep row 4 with the records for John and delete rows 5,6 and 7 till row 8. It will keep row 8 and delete rows 9 to 27 and keep row 28.
Can this challenge be solved using excel alone? if possible guide me else I will like to work with any experienced developer that will help me write a script that will solve this. It is a good learning challenge for me. I hope I can get help here. I will really appreciate. We are all learning.
Thanks in anticipation for a favourable response.