Find Jobs
Hire Freelancers

Urgent help with VBA formulas Excel

£20-250 GBP

완료함
게시됨 거의 5년 전

£20-250 GBP

제출할때 지불됩니다
Hi, Need help to finalise an Excel report. 1st sheet has multiple tables with values 2nd sheet (<< the one that needs help with) has 5 different sections to analyse the data on sheet 1 and display alerts based on a criteria (please refer to the 2nd screenshot to get a better idea). All formulas look alike but they don't work for some reason, it was working on a previous Excel document but not on that one. =IF(COUNTIF(Ignore!$I$4:$I$73,"<="&$G$4)<ROWS($C$5:C5),"",IFERROR(INDEX(Ignore!$B:B,SMALL(IF(Ignore!$I$4:$I$73>$G$4,ROW(Ignore!$I$4:$I$73)),ROW(A1))),"")) So need help to make those formulas work please. Thank you
프로젝트 ID: 20380123

프로젝트 정보

26 제안서
원격근무 프로젝트
활동 중 5년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Hello sir. After opening the 2 Excel screenshots included and reading the description, I am confident I can complete this task for you. Kindly message me but further information so I can start working for you.
£44 GBP 1일에
5.0 (1 건의 리뷰)
1.5
1.5
26 이 프로젝트에 프리랜서들의 평균 입찰은 £95 GBP입니다.
사용자 아바타
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
£150 GBP 2일에
4.9 (383 건의 리뷰)
8.1
8.1
사용자 아바타
Hello, I’m 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 GBP 1일에
4.9 (432 건의 리뷰)
7.7
7.7
사용자 아바타
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 application's formulas work again. I will charge you 90 pounds* and can deliver within five days (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. I am in the top 2% of the freelancers having completed over 300 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 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 GBP 3일에
4.9 (284 건의 리뷰)
7.7
7.7
사용자 아바타
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
£135 GBP 4일에
5.0 (265 건의 리뷰)
7.2
7.2
사용자 아바타
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
£100 GBP 1일에
4.9 (289 건의 리뷰)
7.2
7.2
사용자 아바타
Hi there,I am Excel VBA 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. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me 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
£115 GBP 1일에
4.9 (137 건의 리뷰)
7.4
7.4
사용자 아바타
I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for this project. Please send me a message and we can move forward with your project.
£50 GBP 1일에
4.9 (99 건의 리뷰)
6.1
6.1
사용자 아바타
Hi, I can write a VBA code to display the alerts according to your criteria. I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets) as an Industrial Engineer at Michelin Romania . I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
£110 GBP 2일에
5.0 (22 건의 리뷰)
5.3
5.3
사용자 아바타
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
£60 GBP 2일에
4.9 (66 건의 리뷰)
5.5
5.5
사용자 아바타
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel
£98 GBP 3일에
4.6 (45 건의 리뷰)
5.6
5.6
사용자 아바타
Hi Good Day! A serious freelancer here. I can help you. Please message me. I've done a lot of Reports templates using MS Excel formula and VBA macro. Please consider my bid. 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. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. 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 GBP 7일에
4.9 (50 건의 리뷰)
4.9
4.9
사용자 아바타
Hi, I will be glad to help you meet your deadline for this report. I have years of experience optimizing and automating reports in excel. I can turn the job around fast. On the top of it, we can discuss how we can avoid encountering same issue in your formula in the future; I'm updating your existing formula or introducing new set of array formula if ok with you. I'm giving you a very reasonable quotation which is below the usual service fee range for this type of job. I hope to discuss with you the details of job further.
£70 GBP 1일에
5.0 (25 건의 리뷰)
4.9
4.9
사용자 아바타
Hello! Please Share the file ,delete all leave the first row with info. Ill check it. Regards, Emiliano Excel Expert.... .... ...
£30 GBP 1일에
5.0 (14 건의 리뷰)
4.3
4.3
사용자 아바타
I can do the job! Project looks straight forward. I would need to see the actual excel to debug and test solution. I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Office and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
£30 GBP 1일에
5.0 (25 건의 리뷰)
4.4
4.4
사용자 아바타
Hi There, I am interested to your project. I am an Excel expert and have a great eperiences in excel automation with formulas and vba since my first career 15 years ago. I assured that you will get high quality / high accuracy / high turn around service with best price. I have read through your project desc, checked screenshot attachment and understand your needs I can assist you to solve formulas issues in your spreadsheet and make it work as per normal. Please contact me to discuss further details. Thank you. Best Regards,
£40 GBP 1일에
4.9 (27 건의 리뷰)
4.2
4.2
사용자 아바타
I'm a very talented Excel developer and intelligent problem solver and I'm confident I can help you. You have a copy of the old version that was working? If so comparing old and new versions would very much help in the problem solving. It is probably something simple that is preventing it from working, but it is just not apparent. Contact me please. Thanks, Ryan
£135 GBP 7일에
5.0 (2 건의 리뷰)
2.2
2.2
사용자 아바타
Hello, I read your project description and understand all. I have rich experience in Fromulas, Excel VBA and Macros. I will make the perfect product what you want. I promise to complete your project within your time and budget beyond your expectation. I am willing to work at lower pay. Let me know when we can discuss and share all.
£90 GBP 2일에
5.0 (2 건의 리뷰)
1.5
1.5
사용자 아바타
Dear sir, Madam Quality work within your deadline and budget will be provided. Please feel free to contact me through inbox. I have more than 5 years’ experience in the field of academic and research writing. I am good at business writing, Report writing, Research writing, Technical writing. Please hire me through my profile to offer your project
£135 GBP 7일에
0.0 (2 건의 리뷰)
1.7
1.7
사용자 아바타
I can help you with your work and I can do it quickly at the same day! Just let me work with you. I have the skill in advance excel.
£28 GBP 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hello there, Hope you are doing well. As per your need. I am having around 15+ years of experience in mobile & .NET technologies. I am expert in asp.net MVC, Web API, asp.net, WPF, AngularJs, ReactJs, ReactNative, Xamarin, Sharepoint, TypeScript, ExtJS, YUI, JQuery, Bootstrapper frameworks. I am interested in longterm relationship which should be fruitful for both of us. Looking forward a positive response from your end
£250 GBP 15일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED KINGDOM)
LONDON, United Kingdom
5.0
1
결제 수단 확인
6월 21, 2019부터 회원입니다

고객 확인

이 거래선이 등록한 다른 일자리

Help finalise Power Query automation
£18-36 GBP / hour
감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.