Hi,

I have the formula below which retrieves the highest value within a range but only the one of the values in the range (Column x) is a negative. The formula works fine but I now need to change it to only return the value from the first 26 rows of data that it finds.

My actual dataset contains multiple people each with >100 rows each, but I'm only interested in the first 26 rows.


=IFERROR(SUMPRODUCT(MAX(('Report'!$A$2:$A$10000=$F7)*('Report'!$B$2:$B$10000=Calculations!$B7)*('Report'!$X$2:$X$10000<0)*('Report'!$W$3:$W$10001))),"")
I've had a try at offset or coutif but can't get it too work!

Any ideas?

Thanks in advance