Tamamlanmış

Construct Macro for deleting outliers in excel

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.

Beceriler: Veri İşleme, Excel, Yazılım Mimarisi, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: excel project predecessor macro, macro paste excel project, write macro cut paste excel, calculating an outlier in excel, excel trimmean if, trimmean excel, trimmean pivot table, remove outlier excel formula, how to remove outliers in excel scatter plot, average without outliers excel, excel remove outliers standard deviation, data processing, software architecture, excel, visual basic, visual basic for apps, cut paste macro basics vba excel, macro cut paste excel 2003, macro copy paste excel, macro internet explorer excel

İşveren Hakkında:
( 1 değerlendirme ) Rotterdam, Netherlands

Proje NO: #16730174

Seçilen:

P0L

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.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(282 Değerlendirme)
7.2

Bu iş için 30 freelancer ortalamada €33 teklif veriyor

jaylancer43

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(641 Değerlendirme)
8.3
schoudhary1553

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. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(298 Değerlendirme)
7.6
ksriniravi

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(165 Değerlendirme)
6.7
SShtv

Your task is clear to me and I am ready to execute the project for 25 EUR for 1 day. I have successful experience performing similar work. This is one of them. [login to view URL] Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(61 Değerlendirme)
5.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(86 Değerlendirme)
5.9
satishtl

- Can delete rows depending on the cell values from two cells forms a outlier. - Based on the outlier value in comparison to a specific value and then delete - Also track the number of rows deleted as final message. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(52 Değerlendirme)
6.1
vaidyag

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. If you can provi Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(15 Değerlendirme)
5.2
prabakarm23

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde34%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(65 Değerlendirme)
5.1
vsprybhanu

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(68 Değerlendirme)
5.2
aubrey03

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(52 Değerlendirme)
5.1
rumarahman

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.

in %bids___i_period_sub_35% gün içinde29%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)
4.9
sloker18

I am proficient with excel macro/VBA development, I can write the macro to find out the outlier per your specification and deliver the functions as specified in your requirement, if you are interested feel free to mess Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(45 Değerlendirme)
4.9
osmanaydin

Hello sir, I am interedted in your project. I would like to discuss details via pm. Yours sincerely,

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(18 Değerlendirme)
4.3
Maheshpatel107

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(17 Değerlendirme)
4.6
aminw

Hi, For starters, Thank you for posting your requirements with such clarity. Don't see that very often. :) Regarding your requirement, I understand that you need a flexible system, which you can change your to Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(6 Değerlendirme)
4.3
nelumindralal

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

in %bids___i_period_sub_35% gün içinde44%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)
4.2
conforti

I can do this job check my profile I can do this job check my profile I can do this job check my profile

in %bids___i_period_sub_35% gün içinde19%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
3.7
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas and Macros using VB, the most important thing is that I can d Daha Fazla

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
3.8
PabloMN

Hi! i have great experience with vba in excel and i can make your project done. Just send me the file and i will have it done for tomorrow.

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
2.4
in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.3