I checked again... I am getting the results as expected...
Pl. make sure that the 5 is entered as a number

If I enter 5 the formula works
If I enter '5 then it retruns #n/a as it is designed to do.


"BNT1 via OfficeKB.com" wrote:

Hi Sheeloo

Returning #N/A despite one cell in the range having value of 5

I did enter as an array formula, but no difference

Any idea's?

Brian