Good Morning XOR LX,
Thanks for all your time on this.
Translated:
=WENN(N2="No";0;SUMME(--(HÄUFIGKEIT(KKLEINSTE(WENN($B$2:$J$31=M2;ZEILE($B$2:$J$31));ZEILE(INDIREKT("1:"&ZÄHLENWENN($B$2:$J$31;M2))));5*(ZEILE(INDIREKT("1:"&ZEILEN($B$2:$J$31)/5+1))-1))>0))+(N2<>"Yes"))
Works perfectly.
Once again thank you for all your help.
Regards
Jeremy
Bookmarks