In the formulas in column I, currently:

=IF(OR(ISNUMBER(B41),(ISNUMBER(C41)),(ISNUMBER(D41))),(LARGE(B41:D41,1)),(""))

Can it be changed to:

=IF(OR(ISNUMBER(B41),(ISNUMBER(C41)),(ISNUMBER(D41))),(LARGE(B41:D41,1)),0)

This way a 0 will appear in column I instead of a blank, leaving blanks only where there is truly no data in previous columns (the blanks in between data sets). Unless you have data sets containing mostly negative numbers, 0 would never be returned as the #1 rank (just an assumption).

If that can't be done, we can probably tweak the array formula I gave you to include another logic check.