Finding the largest number in an array which does not correspond to x

[mac8528]

Hi,

I'm trying to find the largest number in an array which does not correspond to x, which in my case equals 2958465, with the following formula:

{=IF(B39="";"";IF(MAX(IF($H$4:$H$2500=H39;$N$4:$N$2500))=2958465;LARGE(IF($H$4:$H$2500=H39;$N$4:$N$2500);2);IF(LARGE(IF($H$4:$H$2500=H39;$N$4:$N$2500);2)=2958465;LARGE(IF($H$4:$H$2500=H39;$N$4:$N$2500);5);MAX(IF($H$4:$H$2500=H39;$N$4:$N$2500)))))}

My thought behind it was that the number which it should not correspond is the largest. However, in some cases it turned out to be also the 2nd and 3rd largest.

Seeing as this is obviously not working, could anyone please help me with simply finding "the largest number which is not equal to x"?

Thank you so much in advance!

M

[NBVC]

How about?

=IF(B39="";"";IF(MAX(IF($H$4:$H$2500=H39;IF($N$4:$N$2500<>2958465;$N$4:$N$2500)))))