|
|
#8
03-12-2018, 01:14 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Picking value from a certain cell under certain conditions | kao | Excel | 1 | 09-07-2017 09:34 AM |
| Average of highest 7 out of nine quizzes | wallace990 | Excel | 2 | 05-16-2017 01:51 PM |
| Fetch highest number | am_gup123 | Excel | 2 | 03-23-2017 01:56 AM |
| Highest & lowest Numbers | ibrahimaa | Excel | 3 | 04-23-2012 07:52 PM |
| Page number picking up heading numbering?! | Ulodesk | Word | 0 | 09-24-2009 01:56 PM |
Windows 8 
Office 2016
Threaded Mode