Hello Solved the 3D Indirect Alphanumeric Year myself, 2 versions attached, both 3D Indirect Tabs summary. 1. YEAR date TAB names. 2. Alphanu...
Hello FYI: Posted elsewhere as not intending full REWORK! For what is likely to be 1 formula to correct in EV YEAR TOTAL (Columns B-P). But co...
Hi Anders I understand your theory and did try previous to deconstruct it to the following for the purposes of 1xbreak, but as mentioned before, th...
Hello Anders Your right there are no errors or issues with formula you provided or the worksheet. Just was asking for a variation of ...
Hi Anders 2 more questions, your short-hand formula edit if was just : Q1: BREAK1 START & END, for Row2? Q2 BREAK1&2 START ...
Hello. File Attached. Status: Done/Finished/Ready! Edited rest of workbook (JAN-DEC) with your concise formula, much easier to edit/follow. Ch...
Hello Anders, exactly brilliant, thanks much more concise! Guess only refers end threshold because after midnight is night hours?! When applied to...
Hello Thank you for assistance! again all absolutely right, many thanks. Updated file attached. The use of * I wouldn't have anticipated in the...
Hello Again! I need your expertise again! file attached updated Need Multiple Criteria Countif/SumProduct/Sumif to sum number of "Y" in column D ...
UPDATE! Sorted with SumProduct & SumIf variation: =SUMPRODUCT(SUMIF('WK1 DATA'!$D$2:$D$12,A2,'WK1 DATA'!$L$2:$L$12)) File Attached. Th...
Hello, edited file attached! oh yes just find Excel 2003 is easier for data validaiton & visual basic, but it lacks time saving features of sli...
Hello Mynda Thank you for prompt reply, use Excel 2003 prefer the clean & simple menus, 2010 just seems clustered with too many menus. Need ...