# 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

Habilidades: Procesamiento de datos, Excel, Matemáticas

( 0 comentarios ) Brisbane, Australia

Nº del proyecto: #18321322

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 Más

\$100 AUD en 0 días
(409 comentarios)
6.8

## 13 freelancers están ofertando el promedio de \$195 para este trabajo

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 Más

\$500 AUD en 10 días
(295 comentarios)
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 en 5 días
(87 comentarios)
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 Más

\$100 AUD en 0 días
(55 comentarios)
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 Más

\$100 AUD en 1 día
(65 comentarios)
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 en 0 días
(16 comentarios)
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 Más

\$200 AUD en 2 días
(7 comentarios)
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 Más

\$110 AUD en 1 día
(14 comentarios)
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 en 10 días
(2 comentarios)
1.9
RavinduJayzz

\$100 AUD en 1 día
(2 comentarios)
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 en 3 días
(0 comentarios)
0.0
ChiritaChiritas

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

\$155 AUD en 1 día
(0 comentarios)
0.0
Hartono1093

I will do it the best

\$333 AUD en 10 días
(0 comentarios)
0.0