Probably with another hidden sheet - yes. But I don't have a clue how you get numbers into in your table on Sheet4 or what they mean!
To get only last number before 0 returned is easy. Look at attached version. (I renamed sheets, removed variant with empty cells equaled with 0's, and defined Tables on all sheets. With Tables defined, on hidden sheets ranges with prepared formulas will be easier to find, and on Main sheet formulas are added automatically whenever you add a new pick.
|