Find Jobs
Hire Freelancers

Excel function and macro needed

$30-250 USD

Completed
Posted almost 4 years ago

$30-250 USD

Paid on delivery
I need to analyze 275,587 lines of data. I need to know what the max and min time for each day. I would like to have the function to provide me those numbers and macro to run every time new data is uploaded.
Project ID: 25807713

About the project

58 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear Sir, I have read your project details carefully and understand it clearly.. I can make your desired Excel function and macro by maintaining 100% accuracy of your data absolutely as you want. I am an Excel Formula Generation, VBA Macro Coding and Automation Process expert with 5* ratting. I can start right now, please message me to discuss more. Regards, Anowar
$30 USD in 1 day
5.0 (397 reviews)
6.8
6.8
58 freelancers are bidding on average $81 USD for this job
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will calculate the min and max values and will run whenever new data is uploaded. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $90* and can deliver within a day (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having, I have completed nearly 400 projects successfully in 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$90 USD in 1 day
5.0 (553 reviews)
8.5
8.5
User Avatar
Hi there,I am a Excel Macros expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Please feel free to initiate the chat so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$165 USD in 2 days
4.9 (194 reviews)
7.9
7.9
User Avatar
Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$75 USD in 1 day
5.0 (502 reviews)
8.0
8.0
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully, I am proficient with Microsoft Excel and macro/VBA development, I can write the function as requested. Would be great if you can share your workbook for more context, kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.
$100 USD in 1 day
5.0 (163 reviews)
7.6
7.6
User Avatar
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the file - I would come up with a macro as required. I can set it up such that as and when data is uploaded, the macro automatically runs on its own. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Week Ahead! Srinivasan Krishnamoorthi
$60 USD in 2 days
5.0 (260 reviews)
7.2
7.2
User Avatar
Hello there, I am an Excel expert and I can set the trigger code to run each time your value added and generate by functions. Please contact and share detail information. We can start now. Thanks.
$50 USD in 1 day
5.0 (233 reviews)
6.6
6.6
User Avatar
Hi, I am an experienced professional in Exel VBA, Excel advance formulas, pivot tables, dashboards etc. I can help you to automate your excel file for creating visually appealing and interactive reports. I have automated so many excel files over two years. Please see my previous projects and contests. I can start immediately if needed. Thanks
$80 USD in 2 days
5.0 (81 reviews)
6.8
6.8
User Avatar
Hey there! Your project jumped out at me, and I would love to help you out with it. I specialize in Excel and Excel Formula Creation. I'm a detail-oriented person who delivers given projects on deadlines. I read through the entire project and understood it. I am able to create a formula and macro to analyze 275,587 lines of data. The formula will generate the max and min time for each day and the macro will run every time new data is uploaded and generate the max and min. I'm capable of handling your project and will provide a 100% accurate outcome. This is an ideal project for my capabilities. I'm looking forward to work with you. Check my reviews to get an idea about my work. I'm online at the moment, feel free to initiate a chat; we can discuss further regarding your project. Hope to hear from you. Best Regards, Ravindu :)
$50 USD in 1 day
5.0 (71 reviews)
6.4
6.4
User Avatar
Hi there, I can create a macro for you as per your requirements. I’m an Excel VBA expert and have 5+ years of experience in creating complex automation tools, formulas, databases, queries and macros. Please massage me to discuss more. Regards, ravinder
$30 USD in 1 day
4.9 (155 reviews)
6.1
6.1
User Avatar
Hello I can get you a simple macro that anaylse the data and get the max and min execution time. I can start right away. Please ping me if interested. Thanks Gokul
$30 USD in 1 day
5.0 (119 reviews)
6.2
6.2
User Avatar
Hi, Greetings, I thoroughly go through your project description. I am qualified Microsoft office specialist with over 2 years of experience and also a VBA developer. I will create a custom function and a macro as required above. can you share the data file with me? I am looking forward to your response Regards Farrukh
$40 USD in 1 day
5.0 (44 reviews)
5.8
5.8
User Avatar
hello sir i can do this work .... i am an expert in excel and have done many such projects in past with excellent ratings open a chat session to discuss thank you hope to hear from you
$50 USD in 1 day
4.9 (100 reviews)
5.6
5.6
User Avatar
Hello, I am an expert in macro specialist and can do project quickly. Please ping me for further details..............thanks Quick turnaround
$80 USD in 1 day
4.9 (85 reviews)
5.5
5.5
User Avatar
Hi, I am a scholar from IIT Delhi and IIM Calcutta, 2 of the most prestigious Engineering and MBA colleges of India. I have gone through your requirement and can do this through Excel VBA. I have done Excel VBA projects before and can complete this project with 100% accuracy in 1 day. Please message me once before awarding this project so that we can discuss the exact requirement further. Thank You, Antriksh
$50 USD in 1 day
5.0 (42 reviews)
5.2
5.2
User Avatar
I can help you here. I have over 15 years of data analysis and macro creation in Excel. Please let me know if you would like to discuss further.
$128 USD in 2 days
5.0 (11 reviews)
5.0
5.0
User Avatar
Hi, Good Day! I can help you building an Automated tool using excel and vba macro. Can you share the file and full requirements so I can assess how much time I needed to complete it. Please message me to discuss more about the project and I can also send you some of my works to help you decide on hiring me. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. I also done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$50 USD in 2 days
4.7 (79 reviews)
5.5
5.5
User Avatar
Hi, I'm Pranjal Kothari from Mumbai, India! I can design a custom VBA function to parse through any range of values - 25000 or more and generate the max and min value and this could even be made dynamic depending on how your new data is updated. If you can chat with me I will first provide you a fully working file representative of the project before accepting your project so that you can verify the quality of my work. Award me the project only when I have fully completed your task and you are completely satisfied with the final file - that way you too can be sure of my 100% commitment. ABOUT ME: I am proficient in Excel VBA. I have designed varied kinds of automation software and utility programs in VBA that have saved vast amounts of time and effort for my customers. Your satisfaction is my prime priority proof of which are my reviews and repeat hire rate: More than half of my customers have come back to me for a repeat order! You can even reach out to me for additional assistance if required after the project is over. Looking forward to a prompt response from you! Regards, Pranjal Kothari
$30 USD in 1 day
5.0 (39 reviews)
5.4
5.4
User Avatar
Hello!! Am very interested in ur project and I'm an expert in PDF/Word/Excel/Excel Marcos/VBA/Visual basic/Copy typing/Data Entry/Data processing and would like to help you with your project. Please ping me for further discussion.
$30 USD in 1 day
5.0 (39 reviews)
4.9
4.9
User Avatar
Hello, I have gone through with contents and attached files to understand the requirements. I am interested to do this work and break your huddle. Please allow me to do this job. I am available to support you 24*7 just ping me once. I have a good knowledge of Excel, Advance Excel functions and VBA. I know Sumifs, Countifs, Averageifs, Index, Match, Vlookup, Hlookup, Sorting, Pivot table, Slicers, Developer functions & Conditional formatting, etc. Please check my portfolio to know more. I have created multiple VBA macros and make our work easier for everyone. Thanks, Jitender Kumar
$150 USD in 2 days
5.0 (24 reviews)
4.7
4.7
User Avatar
Hi! My name is Ana and I know very good excel functions. Select me for this project and I'm ready to start right now.
$30 USD in 1 day
5.0 (20 reviews)
4.8
4.8

About the client

Flag of UNITED STATES
Columbus, United States
5.0
5
Payment method verified
Member since Mar 27, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.