Posted to microsoft.public.excel.worksheet.functions
|
|
Length that falls within a length interval?
Thanks a lot! It works!
--
igor
"shg" wrote:
Maybe like this:
Code:
--------------------
--A-- -B- ----C---- ----D----
1 Begin End Interval1 Interval2
2 237 356
3 356 491
4 313 377 43 21
5 289 357 67 1
--------------------
In C4 and copied across and down
=MAX(0, MIN(C$3, $B4) - MAX(C$2, $A4) )
--
shg
------------------------------------------------------------------------
shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30483
|