I have a list of data.
This contains attributes of points of a road with a reference of distances in metres called the chainage (column A). Column A is all values.
I want to identify for removal all rows where the chainage between the next and the previous entry is <20. If it is 20 or greater it needs to be identified to be kept.
After removal there should be NO entries of <20 unless the subsequent entry is 20 or greater.
See attached example showing yellow highlights with whether to keep or remove.
My full worksheets have about 10,000 rows each. There are five workbooks.
I do not want you to remove any data, just identify those to remove.
Được trao cho:
Hi I can create a macro for your workbook which will work on your all 5 [login to view URL] i am okay to show some sample as [login to view URL] discuss in chat. Regards
12 freelancer đang chào giá trung bình $23 cho công việc này
m done this very fast, we have the team of dedicated and professionally experienced seo that is ready to be work according to your job requirement.