Lengkap

Urgent help with VBA formulas Excel

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

Kemahiran: Excel, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: vba macro excel unicode, vba sql excel, create formulas excel, formulas excel money, start vba script excel, vba word excel, run vba script excel, lock formulas excel, vba unzip excel, simulation vba access excel, solidworks vba create excel, vba export excel data mysql, morgage formulas excel, vba refresh excel web query, vba script excel xml, excel 2003 paste clipboard vba macro excel, i need a lawyer to help me in getting a divorce but i don t have money in lagos

Tentang Majikan:
( 0 ulasan ) LONDON, United Kingdom

ID Projek: #20380123

Dianugerahkan kepada:

Youssoufsd

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 dalam sehari
(0 Ulasan)
0.0

31 pekerja bebas membida secara purata £104 untuk pekerjaan ini

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Lagi

£100 GBP dalam sehari
(712 Ulasan)
8.4
schoudhary1553

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. Lagi

£150 GBP dalam 2 hari
(317 Ulasan)
7.9
P0L

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 dalam sehari
(299 Ulasan)
7.2
paris2785

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 Lagi

£90 GBP dalam 3 hari
(211 Ulasan)
7.3
zekovicm

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 ag Lagi

£115 GBP dalam sehari
(106 Ulasan)
7.1
elqueabandona

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 proje Lagi

£100 GBP dalam sehari
(224 Ulasan)
6.9
asadkhan3533

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 dalam 4 hari
(127 Ulasan)
6.4
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f Lagi

£100 GBP dalam 3 hari
(83 Ulasan)
6.6
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Lagi

£100 GBP dalam sehari
(109 Ulasan)
5.8
SShtv

Hello, I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These Lagi

£75 GBP dalam 2 hari
(79 Ulasan)
5.9
c4cuteconain

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 pr Lagi

£50 GBP dalam sehari
(50 Ulasan)
5.6
afenache

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 Lagi

£110 GBP dalam 2 hari
(19 Ulasan)
5.2
sonarkaushik

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 dalam 3 hari
(45 Ulasan)
5.6
StormLion227

Hello. Nice to meet you. I have good skills in "Excel, Visual Basic, Visual Basic for Apps", so that i 'm very interest to your project. I have checked description of your project "Urgent help with VBA formulas Exce Lagi

£150 GBP dalam 3 hari
(10 Ulasan)
4.9
dungforever

Hi ⭐⭐⭐ I can complete your project in 1 day ⭐⭐⭐ I've read your requirements carefully. I understood your requirement and I have full experience in excel VBA. I am a certified freelancer with great ideas & methodologies Lagi

£135 GBP dalam 7 hari
(6 Ulasan)
3.9
gsanggara

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 Lagi

£40 GBP dalam sehari
(25 Ulasan)
4.1
IgeS

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 a Lagi

£70 GBP dalam sehari
(2 Ulasan)
3.7
paulodayto08

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 develop Lagi

£50 GBP dalam 7 hari
(27 Ulasan)
3.8
writingapp

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 dalam 2 hari
(6 Ulasan)
3.4
ielucerotrad1

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 Lagi

£30 GBP dalam sehari
(6 Ulasan)
2.4