?? Same error! ?? I'll leave it in MANUAL EDIT for 1st DATE of YEAR, 01-01-YY, totally bullet proof. Suggested formula have "ricochet" effect, e...
Hi Phil, Right I'll try those..... & also hard to dodge the velocity of this the previous Formula did actually work, the Worksheet Tab name jus...
Hi Phil You are right direct edit of 1 cell 1 character once a year is no big deal! But feel knowing the answer to this may prove useful in the ...
Hi. It is 1 only character which I won't overlook. But what would a Formula look like that could use a tab name as the year? It does sound tr...
So I know Autofilter suits my purposes often too! But if the later functions actually work for me the individual, I doubt that. But in that I kn...
Thanks for those Formulas, workbook completed! Appreciate new Excel features may save time, but older versions then 2016, seem to be less obvious w...
Many thanks Philip those suggestions worked! 1 other question: when answer is zero = 0, for these Calcs how to display blank space? O7 =MIN(IF(A...
D6 =INDIRECT(TEXT(A6,"yyyy")&"!$V$32") Thanks this worked for Columns B-L, few things: 1. If no data, how to change FALSE to nothing? 2. ...