Construct Macro for deleting outliers in excel

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.

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 MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you. Please pay me once job is 100% done. Please initiate a chat before award as I have few queries to confirm so that I can ensure its doable.

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... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

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 message me, await for your precious reply to discuss in chat and work on the project.

A proposal has not yet been provided

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 indicating no. of rows deleted, deleted rows on separate sheet and Graph). I have 18 years experience in using Excel as part of my daily work life. Over the last 22 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Weekend! Srinivasan Krishnamoorthi

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, creating summary of actions etc. So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra

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.

- 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. - Deleted rows can be moved to another sheet for further investigation. - A simple graph can be generated from the deleted rows. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl

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

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 provide more details about the work then will be able to provide a more accurate pricing and timelines. Thanks Regards Vaidy

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 deleted. I have 5 years experience of software development with macros. Thanks Mahesh

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 Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction.

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 tolerance of matching data points and also include a tracking and reporting mechanism for the outliers. What you probably also need is when the column is moved to a different sheet, you need an identifier, to understand which column in the original sheet was matching the columns in the new sheet. I have over 15 years of experience in the corporate world working for large companies like Volvo, Dupont, Accenture, A.C Nielsen and this is something which I have done as a part of "Master Data Management" with a previous client. I believe I am uniquely suited to help address your requirements, by not only addressing your current requirements, but also being able to preempt what you need or other functionalities of excel which can be leveraged to fulfill your requirements. Of-course my services come at a price. You can definitely try the €20 bidders, and hope they don't end up wasting your time, or your can have a quick chat with me and I will be happy to address your queries. Regard Amin

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 do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.

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

I would loop through the data range in reverse and check the two values for each row, if it meets the criteria i would copy the row to the second sheet and then delete the row from the original. I would be able to do all the things you say would be nice to have. Due to the nature of the way Excel works deleting rows can be slow on large sets of data, it might be worth looking at the option of clearing the rows contents and then sorting the original data at the end of the macro as this can be a faster approach. Hope to hear from you

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 organisation I am working for.

I m right person for this job

Dear Sir/Madam It´s been understood the requirements. I am able to start. ASAP. Personalized service, full back-end and front-end programming. Software architecture and engineering. Background Samples at my portfolio tsftportfolio wordpress com PROCEDURES My work methodology (from Agile:Scrum, XP) My usual roadmap: -Project management (PM easy shared by mail auto) -Analysis, programming (PM) -Programming, APIS, Integration (PM) -Production Remote Work -Online distance working -Online collaboration: easier system for you. -Daily communication automatized workflow. -Extreme programming, Agile methods. I look forward to work with you, Kind regards.