Hi Domenic,

Thank you very much for sample file - I must have made an error when
transferring the Formulas. The #N/A errors are no mo I know get calculated
Intervals.

Unfortunately, I did not explain that I was looking for the calculated
Intervals of the two criterion to be displayed across their own individual
Row where they intersect - Interval calculated per your Formula but for each
occurrence of the paired criteria eg: 82 and 80 - Intervals displayed across
the entire Row where they intersect. I would have numerous criterion
vertically but only one horizontally. In the example below, your Formula
would correctly return blank for Intervals relating to criteria 80 80.
Criteria 81 80 should return various Intervals across that Row and the same
for the others such as 82 80 and 83 80.

Example Chart / Matrix Layout:
Cell Ref. A2 and B1 criterion 80 and 80
Cell Ref. A3 and B1 criterion 81 and 80
Cell Ref. A4 and B1 criterion 82 and 80

Criteria B1 houses 80
A2 houses 80
A3 houses 81
A4 houses 82 16 8 2 12 20 30 3 5 10 11 14
A5 houses 83

Cheers
Sam

Domenic wrote:
As per your request, I've just emailed you a sample file. Post back if
you need further help!

Cheers!

Would very much appreciate sample file.

Cheers
Sam


--
Message posted via http://www.officekb.com