Đã hoàn thành

Data in Excel Manipulated

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.

Kĩ năng: Excel, Xử lí dữ liệu

Xem nhiều hơn: transfer data excel multiple sheet access table, data excel sheet macro, transfer data excel word, basic data manipulation, excel data handling, data manipulation in excel 2016, data manipulation skills, how to use excel to analyze and manipulate data, excel data manipulation course, excel data manipulation test, data manipulation in excel tutorial, fetch data excel files, export jsp data excel javascript, perl script retrieve data excel, export data excel database java, convert pdf data excel sheet, read data excel file, extract data excel drop form html, send data excel program, adonet sql large data excel export

Về Bên Thuê:
( 4 nhận xét ) Brisbane, Australia

ID dự án: #23534777

Được trao cho:

akritisood94

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

$20 AUD trong 7 ngày
(73 Đánh Giá)
5.4

12 freelancer đang chào giá trung bình $23 cho công việc này

Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Thêm

$50 AUD trong 7 ngày
(255 Nhận xét)
7.0
muradeltaher

Greetings! My Name Is Murad And I’d like to be considered for your position. I Have read Your Instructions and well understood Data will be researched perfectly and all details will be put on a well organized exce Thêm

$30 AUD trong 2 ngày
(76 Nhận xét)
5.0
ravinderkumar248

Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o Thêm

$30 AUD trong 2 ngày
(17 Nhận xét)
4.5
engrranakaleem21

Hi, I have understand the project requirement and interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more and start the project. Than Thêm

$10 AUD trong 1 ngày
(27 Nhận xét)
4.2
vwandah0

Once a confirmation of project is assigned you should have it in at most 12hrs...

$25 AUD trong 2 ngày
(0 Nhận xét)
0.0
tawal7

Dear Hiring Manager At my take my sincere respect. I have gone through your project description. After that, I am able to understand. I have enough skill to the project. Moreover, I have a lot of experience in exce Thêm

$35 AUD trong 7 ngày
(0 Nhận xét)
0.0
Jeuneideline52

Good evening, my name is Mideline Jeune, Technician in data processing, student in management of the financial institutions, writer in French language, graphic designer and professor of data processing. With regard t Thêm

$10 AUD trong 7 ngày
(0 Nhận xét)
0.0
$25 AUD trong 1 ngày
(0 Nhận xét)
0.0
EmanMuhamad

Hello there ,                  I have 5 years of experience in translating and teaching English(American accent ) as a second language for both normal and VISUALLY IMPAIRED ESL students in university scholarship progra Thêm

$11 AUD trong 2 ngày
(0 Nhận xét)
0.0
madda2011

Hello. I have the experience of a full time data entry job for more than 2 years so I have the accuracy and speed to have this task done as soon as possible. I work with Excel every day so I can complete this task very Thêm

$15 AUD trong 1 ngày
(0 Nhận xét)
0.0
ankitbhati19947

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.

$20 AUD trong 1 ngày
(0 Nhận xét)
0.0