# Excel function to identify (and calculate) if a 2 value data range is between multiple 2 values ranges of values

I am an independent consultant in energy sector and require assistance with a small excel project.

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

( 0个评论 ) Brisbane, Australia

## 授予：

MimiFL

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 exe 更多

\$100 AUD 在0天内
(409条评论)
6.8

## 13 威客就此工作平均出价 \$195

schoudhary1553

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 j 更多

\$500 AUD 在10天内
(295条评论)
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

\$222 AUD 在5天内
(87条评论)
6.0
datakillers

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 cl 更多

\$100 AUD 在0天内
(55条评论)
5.6
mail2vimalarora

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 c 更多

\$100AUD 在1天里
(65条评论)
5.3
webanis

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

\$111 AUD 在0天内
(16条评论)
4.0
lightingdavid

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 更多

\$200 AUD 在2天内
(7条评论)
4.0
ReneRondon

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 更多

\$110AUD 在1天里
(14条评论)
2.8
herguz2017

regards dear sir Can you give me more details of your project? I am an expert in excel and data analysis I can help you with your project

\$200 AUD 在10天内
(2条评论)
1.9
RavinduJayzz

\$100AUD 在1天里
(2条评论)
1.5
anilbitmca

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.

\$300 AUD 在3天内
(0条评论)
0.0
ChiritaChiritas

Progetto sara sviluppato per rispondere a tutte le necessità , mi assicuro che alla fine tutte le richieste verranno soddisfate

\$155AUD 在1天里
(0条评论)
0.0
Hartono1093

I will do it the best

\$333 AUD 在10天内
(0条评论)
0.0