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.
Bookmarks