Help. Cant get the results I need Looking for overlap in ranges

**vincent783** · 07-10-2012, 01:46 PM

I two columns representing page numbers of documents. they need to be sequential without overlap. the pages have been assigned and I have found over lap. I need to find all over laps. my souloution does not work when an offending document is a single page. see below for the results I am getting:

50627 50627 FALSE
50628 50631 FALSE
50632 50633 FALSE
50633 50633 TRUE

row 3 should be true since 50633 is in row 4

I have tried :
=SUMPRODUCT(($F$2:$F$7857<=F7851)*($G$2:$G$7857>=F7851)*($F$2:$F$7857<=G7851)*($G$2:$G$7857>=G7851))>1

(Disregard row and column references in formula: they are to my spreadsheet and the example above is a small portion.)

I did try to search this site, but did not get what I needed.

I will try to attach a sample of m

**Chance2** · 07-10-2012, 02:09 PM

I may be over simplifing this but aren't you just saying:

Please Login or Register  to view this content.

This will say true if the last page is the same as the next page.

**vincent783** · 07-10-2012, 02:17 PM

Yes, it oversimplifies. it would only cath certain types of issues. There are issues that would not identify such as:

1 10
7 8
9 9
10 11

It would not identify first offending document nor sub

this example would return "nothing", false, false, false when it should be true, true, true, true

Thanks, though.

Originally Posted by Chance2

I may be over simplifing this but aren't you just saying:

Please Login or Register  to view this content.

This will say true if the last page is the same as the next page.

**oeldere** · 07-10-2012, 02:36 PM

See the forumrules and this link.

http://www.mrexcel.com/forum/showthr...lapping-ranges

**vincent783** · 07-10-2012, 02:43 PM

This link is mine on a different forum. There are no relpies. I am still needing to identify what the problem with the formula is.

thank you

Originally Posted by oeldere

See the forumrules and this link.

http://www.mrexcel.com/forum/showthr...lapping-ranges

**Pauleyb** · 07-10-2012, 03:03 PM

I'd keep it simple and use an OR formula. Include your formula which seems to work most of the time, and then add checks to see if a number appears more than once for your single page issue.

Pauley