Construct Macro for deleting outliers in excel
€8-30 EUR
Dibayar semasa penghantaran
We need a macro in excel which deletes an entire row, if two cells in a row show an outlier.
Our problem is the following: in large data sets, it might be difficult to find outliers. Therefore, we need a macro. An outlier is defined by the difference between 2 data points. Therefore, the macro should be able to delete a row, if the difference between two columns is smaller or larger than a specific value.
Deliverable: a Macro for in excel which:
Is able to calculate the difference between two columns, for each row.
Deletes the row which contains data for which the difference between the columns is smaller or larger than a certain, given value.
It should be possible to define the value between the two columns by ourselves.
Nice to have:
A message with how many rows were deleted.
The deleted rows are copied to another sheet, so they can be investigated further.
After deleting the rows, a graph is made of the data columns which were investigated.
ID Projek: #16730174
Tentang projek
Dianugerahkan kepada:
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
28 pekerja bebas membida secara purata €34 untuk pekerjaan ini
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) I am an Engineering Graduate with an MB Lagi
Hi there..... Warm Greetings We came along with your request for create Macro for deleting outliers in excel and we reviewed your project description. We'd like to help you with confidence and satisfying results. Lagi
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I can write a macro including all the nice to have features listed (message indicati Lagi
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating rows according condition like deleting, adding rows, creati Lagi
Hi, I am an expert excel worker and I do programming on VBA Excel to gather data from internet automatically. So that I am the suitable one you are searching for, Sir. Thanks.
Hello sir, I am interedted in your project. I would like to discuss details via pm. Yours sincerely,
Hello, I have read your requirements to create macro for delete entire row which does not match given value with column. I will provide macro which copy delete rows to another sheet and will display how many rows del Lagi
Hello, I went thru the project description This project can be done in 2-3 days You may see my previous projects and reviews I am looking forward to hearing from you Thanks regards Thushara
Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv Lagi
I can do this job check my profile I can do this job check my profile I can do this job check my profile
Hi, Timeline of 5 day may get reduce after getting the exact requirements. Relevant Skills and Experience 3+ years of experience in developing VBA macros. Developed multiple tools for clients and internal team in the Lagi