#### richsark

##### Board Regular

- Joined
- Mar 24, 2007

- Messages
- 125

Anyway, this formula was working great since 12-08, but someone came to me yesterday saying there is a flaw in the formula between Company A and Company B

If you note that 10.125.239.0/24 is overlapped with 10.125.236.0/22, yet is marked FALSE

FindDuplicateIPRanges12-26-08-v7-Sorted.xls | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | G | H | I | J | K | L | M | |||

7221 | CompanyA | 10.125.236.0 | 255.255.252.0 | 3 | 7 | 11 | 4 | 8 | 12 | 176024576 | 1023 | 176025599 | TRUE | ||

7222 | CompanyA | 10.125.237.0 | 255.255.255.0 | 3 | 7 | 11 | 4 | 8 | 12 | 176024832 | 255 | 176025087 | TRUE | ||

7223 | CompanyA | 10.125.239.0 | 255.255.255.0 | 3 | 7 | 11 | 4 | 8 | 12 | 176025344 | 255 | 176025599 | FALSE | ||

7224 | CompanyB | 10.125.240.0 | 255.255.255.0 | 3 | 7 | 11 | 4 | 8 | 12 | 176025600 | 255 | 176025855 | TRUE | ||

7225 | CompanyB | 10.125.240.0 | 255.255.255.252 | 3 | 7 | 11 | 4 | 8 | 12 | 176025600 | 3 | 176025603 | TRUE | ||

DottedDecimalMasks |

Can someone please look at the formula to see where the calculation is flawed.

Thanks