Lookup last cell in row that is greater than zero

[Dutch007]

I have this formula that will find last, every third, cell in a row. Problem is that it is finding the zero's. I need this formula to only identify the last, every third cell, that is greater than zero.

= LOOKUP(9.999999999999E+307,IF(MOD(COLUMN(F6:CO6)-COLUMN(F6),3)=0,IF(ISNUMBER(F6:CO6),F6:CO6)))

Thank you.

[daddylonglegs]

You need to change the ISNUMBER check to check for greater than zero, i.e.

= LOOKUP(9.999999999999E+307, IF(MOD(COLUMN(F6:CO6)-COLUMN(F6),3)=0, IF(F6:CO6>0,F6:CO6)))