Tamamlanmış

Excel look up

This is hopefully straightforward. I require an Excel macro to look up a list of two columns. Column A presents changing values and so does column B. When the value in column A reaches 20 or above for the first time, I want to find the lowest value in the adjacent Column B until the values end in the list. The range for the lowest values must start one row below when the value of 20 or above is found.

Here is an example assuming that the first value above 20 is found in cell A5 (and is equal to 22) and the last value in Column A is in cell A26 (and is equal to 44). I would want to find the lowest value in the range B6:B26. The lowest value in range B6:B26 is 12. Then I would want the last value in the list in column A to be recorded as the “Close” value. The result would be:

Lowest = 12 (lowest value in range)

Close = 44 (last value in Column A)

I would want this done also for the first value above 30 in the list.

Also, where the is no data (ie. The value in cells in column A do not reach 20 or 30), then I want “No data” put in the results. It may be that there is data for above 20 but not above 30 also.

Hopefully, the 3 attached examples show this better.

To note, that the input may vary in length but the values will never go beyond 400 rows.

Beceriler: Excel, Excel VBA, Excel Macros

Daha fazlasını gör: excel hlookup, excel lookup multiple values, advanced excel lookup functions, types of lookup in excel, excel lookup vs vlookup, excel match, excel lookup exact match, excel vlookup, excel vba look data sheet, excel look standalone program, making excel documents look good, look cell copy next macro excel, excel spreed sheet look project, excel look good, excel look nice, excel look tidy, word form excel look, excel look professional, excel look phone number list names, excel look name phone number

İşveren Hakkında:
( 6 değerlendirme ) Taunton, United Kingdom

Proje NO: #27897622

Seçilen:

kingqueen369

Hi, Greetings! ✅checked your project details Excel look up Attachments [login to view URL] [login to view URL] [login to view URL] ✅Completed Time : 24 hours(independent and fast workers only) or your requirement deadline . I would Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% GBP
(7 Değerlendirme)
3.3

Bu iş için 11 freelancer ortalamada £13 teklif veriyor

rahul62544

Hi Ok, i will make you a maco for this which will do the work as you described, like finding the Close and Low values, with some conditions. Thanks Much, RK.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(117 Değerlendirme)
6.0
ilkecokay

Hello sir. I have more than enough experience with Excel to accomplish this and i'll do it for the lowest price possible. Please message if interested. Regards. (I will provide you a fully commented code, also if you Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(56 Değerlendirme)
5.3
BAVarun

Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 54 projects on FL. Expertise - Macros Formulae VBA User forms Willing to share a sample of my work done o Daha Fazla

£15 GBP in 7 gün içinde
(41 Değerlendirme)
4.8
Jatin77777

Hello, I have gone through with contents and attached files to understand the requirements. This is pretty straight forward task and I am interested to do this work and break your huddle. Please allow me to do this job Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(13 Değerlendirme)
4.1
aanik8939

Hope you are doing well. I have read your project and I have the confidence to do the work with 100% accuracy. Please knock me for the project I want to do this. I have experience in Data entry, Data processing, Excell Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
Khan99531

Hello I am faizan I am a data entry expert I have 3 yer experience in this field like Exel ma's word an power point and tally.. I will glad to work with you

£15 GBP in 7 gün içinde
(0 Değerlendirme)
0.0
SANJESHRAWAT22

Hello,i am an enthusiastic data entry specialist,i can input data with accuracy in reasonable delivery time,please give me just a chance and see my hardwork. BEST REGARDS

£10 GBP in 6 gün içinde
(0 Değerlendirme)
0.0
omaraftab99

Hello, My name is Omar. I read your offer. I have 5 years experience on it. I like that I can provide you the perfect work. Buyer satisfaction is my first priority. I like to do this job. We can discuss about it. I am Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
LightFlights

Hi, This is a straight forward task and can be accomplished in a few different ways. It can include the provision for setting the thresholds interactively, or hard coded. Look forward to being of assistance

£10 GBP in 3 gün içinde
(0 Değerlendirme)
0.0
mdrifat6a

if you want i will do this carefully...i read your requrment so,i interest to do your work..thank you

£14 GBP in 4 gün içinde
(0 Değerlendirme)
0.0