Attached I send an excel file (if permitted)

[hansdecocq]

Hey

Attached in my excel sheet you see dominant #NA.

The array formula works fine (I think)
In the yellow area I have tested several solutions, but none of them works

I hope you can and will help

 

[NARAYANK991]

Hi ,

I am not sure I have understood your problem , but I think the problem was that you were using a multi-cell array formula , where you can use a single-cell array formula.

IFERROR will not work with a multi-cell array formula.

Narayan