Glad to be of help.

Pete

On Sep 24, 5:43*pm, Alonso wrote:
thanks Pete
probably that will work
split in 2 in columns
and get the max between those??
after all
the formula gets only 1 value



"Pete_UK" wrote:
Excel 2003 and earlier versions will not recognise IFERROR, so you will
probably have a #NAME error if you try to load the file on those versions.

With regard to the nesting problem, I suggest you split your formula into
smaller chunks over a few columns and then combine them using these
intermediate columns.

Hope this helps.

Pete