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.
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
Bu iş için 11 freelancer ortalamada £13 teklif veriyor
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.
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
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
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
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
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
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
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