How to do common of n range using C/C++?

[ahmed osama]

Dear All

now i have for example 3 ranges

A: 1 ----------- 5
B: 2-------------6
C: 3-----------7


the common range is 3-------5

how can i do that using Math !!! to be able to do it using c/c++ or excel !!

For all Math Prof. help me thx


bye

 

[safwatonline]

common of n range !!

simple for loops in C or matlab

 

[ahmed osama]

Re: common of n range !!

simple for loops in C or matlab

i need to know HOW ? i mean the algorithm??

thx

 

[safwatonline]

common of n range !!

BTW there is an intersect function in matlab

 

[cherrytart]

common of n range !!

maximum of left endpoints of A,B and C is the lower bound and the minimum of the right endpoints is the upper

 

[harsha_jois]

common of n range !!

Hi ahmed osama.
Cherrytart says the minima and maxima can do it.
You take the smallest range.
compare the lower bounds of other ranges to find the largest.
compare the upper bounds of other ranges to find the smallest.
hope this does the trick
tara

 

[Kral]

Re: common of n range !!

ahmed_Osama,
In Excel, do the following:
Put the lower bounds of the ranges in a column
Put the corresponding upper ranges in the next column
Use the Small, Large Excel Functions.
For your example, say, let colums B3:B5, C3:C5 contain
. 1 5
. 2 6
. 3 7
Put the formula =Large(B3:B5,1) in Cell B6
Put the formula =Small(C3:C5) in cell C6
Cells B6, C6 now contain the upper, lower bounds of the common range.
This essentially implements the scheme outlined by cherrytart
Regards,
Kral

Added after 14 minutes:

ahmed osama,
Ooops! The 2nd formula should read "=Small(C3:C5,1)". I forgot to put in the 2nd parameter of the function.
Regards,
Kral