Excel function to identify (and calculate) if a 2 value data range is between multiple 2 values ranges of values
$100-500 AUD
완료함
게시됨 5년 이상 전
$100-500 AUD
제출할때 지불됩니다
I am an independent consultant in energy sector and require assistance with a small excel project.
Task description:
Columns B and C provide a first set of data intervals. (a top and bottom depth interval). For example in row 14 the interval goes from 816.665 m to 816.833 m.
Columns Q and R provide a second set of data intervals (a top and bottom depth interval). For example in row 14 the interval goes from 781.18 m to 785.18 m and row 15 goes from 769.49 m to 773.49 m, etc.
The task is to develop a formula / function which will check and compare each individual data interval on columns B and C against ALL data intervals in columns Q and R AND to calculate the overlapping quantity, AND show result in the relevant row of column M.
Example 1 (No overlap), the formula in M14 would look at interval 816.665 to 816.833 m (columns B and C) and compare it to ALL intervals in columns Q and R and will find out that interval 816.665 to 816.833 m does not overlap with any of the intervals in columns Q and R and therefore the result in M14 would be 0. - -
Example 2 (Total overlap), on row 27, the formula needs to compare interval 736.908 - 737.199 with ALL intervals in columns Q and R and will find that it does overlap with interval 734.82 - 738.82 (row 18) and therefore the result in M27 will be 0.291 m.
Example 3 (Partial overlap), on row 67, the formula needs to compare interval 531.111 – 534.111 m with ALL intervals in columns Q and R and will find that it partially overlap with interval 529.17 – 533.17 m (row 36) and therefore the result in M67 will be 2.059 (533.17 minus 531.111)
Excel file is attached
Hello, i am serious freelancer with 100% completion rate and i believe i can help you. The logic in calculating the overlapping is not that hard, i just need you to ask you few questions about how would you like to execute this. If you are interested in working with me, please message me and i will try to help immediately.
Thanks, Milan
Hello,
Hope you are doing well.
I can help with you in your project Excel function to identify (and calculate) if a 2 value data range is between multiple 2 values ranges of values. I can assure you the quality job.
I have good experience in Data Processing, Excel, Mathematics. We have worked on several similar projects before!
We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion.
I can assure the 100% job satisfaction.
Thanks,
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
Hi
I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know what my client asking for my work.
I am Alison certified for Microsoft Office and Microsoft Excel. So, you can Trust me for a Best output with complete satisfaction.
Your work will be delivered well in advance with seamless communication & timely response until project is completed. As well as for any alternation and query we are available 24 x 7.
Looking forward for great business deal.
Hello
How are you?
I have reviewed "Excel function to identify (and calculate) if a 2 value data range is between multiple 2 values ranges of values". I have good skills for these (Data Processing, Excel, Mathematics).
I have been working for 7 yrs in this scope.
While we contract and work in our jobs, I will get paid once you have confirmed satisfied result.
If I do not deliver satisfied result, I will never get paid from you.
We can discuss more details to understand more easily if you have other infos.
I hope to work with you.
Thank you.
Hello,
I am ready to discuss project with you.
Being experienced in working on several excel projects related to formula/vba/macro etc. based on that I can quickly help you in developing function that you need to compare values in different columns as mentioned. I am available to start now and want to discuss more specific details.
Looking forward to have further project discussion on chat.
Thanks.
Vimal Arora
Hello. I bid for this project because I'm a professional with a lot of experience in MS Excel and VBA programming (macros). I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget. Please contact me to get more information regarding this project, I'm interested and have time to dedicate. Regards.
Hi,
I am an excel expert and have 8+ years of experience. I can deliver this to you as per you expectation. Please ping me so that i can discuss with you and start working on his.