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.
Được trao cho:
30 freelancer đang chào giá trung bình €33 cho công việc này
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, 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