Hi Welcome to JustAnswer
Can you share that excel to me with above example and let me know what result you need at the end. ?
something like this can only be done with a macro. Please try to give a better explaination.
If you have 50 rows with the same ID#, you want to keep the first 1, and delete the other 49 rows?
Hi I am sorry for late reply, I was off for few day.My email id is :***@******.*** I looked into you sheet and seems like this problem can be resolved by excel's inbuilt function called "Remove Duplicate" which is present in your Data tab.
You can follow below steps to do it :-
Go to Data Tab >> select remove duplicates and then just specify the column. This feature will automatically delete rows for you.
If this solution helps, then please provide your valuable rating to me. Else feel free to post your concern, I will further work on it and resolve all your issues.