Hi a first attempt in F5: =IF(COUNTIF(D$5:D5,D5)>1,"",IF(COUNTIFS(D:D,D5,E:E,"Pass")=COUNTIF(D:D,D5),"Yippee!",IF(COUNTIFS(D:D,D...
Hi All, pivot tables are more efficient to achieve these outputs. One of the formula approaches could be In H4 to be copied down to get a uni...
Hi, you could try: EOMONTH(Q1,-12) instead of EDATE(... Referring to the file you shared =IF(B6=EOMONTH(Q1,-12),B8,SUM(B8:INDEX(B8:Y8...
Hi All, if Excel 2010 (or later version) is available, you could expolit AGGREGATE =IFERROR(INDEX($A2:$G2,AGGREGATE(15,6,COLUMN($A:$G)/ISNU...
Hi, thanks for sharing kind feedback. Regards
Hi All using an helper colum in D2 to be copied down in D2:D19 =(COUNTIF($A$2:A2;A2)=1)*MAX(INDEX(($A$2:$A$19=A2)*$C$2:$C$19,0)) In N16 ...
Hi, a first approach without disturbing very complicated (for me) formulas. In E8: =IFERROR(MID(REPT(F$1,F$3)&REPT(E$1,E$3)&REPT(D$1,...
Hi All, I'm quite sure you cannot avoid VBA. As I don't know Vba very well, I've adapted some codes I have in my toolbox. A big thanks to the cr...
Hi, maybe =COUNTIF(A:A,"*-0114*") could do the trick. If you'd need to check the substring (-0114) only in the last 8 digits =SUM...
Hi, thanks for your kind feedback. Greetings from Firenze
Hi All, in J35 array entered before to be copied below: =IFERROR(INDEX(E$2:E$2000,SMALL(IF(FREQUENCY(IF((B$2:B$2000=$I$30)*(C$2:C$2000+0=$J...
Hi All, just a small typo in LittleDog!C14: Croissant-Swiss needs an extra "i". I agree to settle on Power Query. An old style formula soluti...
Hi Tigger, hi Tony, first of all, Vba offers far better solutions (see Tony's user defined function) Just for fun I've integrated the former formula...
Hi All, in the attachment I'm using SUMPRODUCT in column J to get Teaching Weeks. Hope it helps
Hi All, a different approach using a formula. =Sumproduct(--(Isnumber(Find(" "&Row($1:$30)&","," "&I2&","))))+Sumproduct(Isnumbe...