Forum Discussion
I need help with fixing formulas for scores without BYE in the score area
I need help with fixing formulas for scores without BYE in the score area
Thanks You
3 Replies
Hi, try repairing the formula in D15:
=LET(in,TRIM(CHOOSECOLS('Yearly Schedule'!A1:F273,1,4,6)),tl,FILTER(in,MMULT(--(in=$A$2),{0;1;1}),""),tw,TAKE(tl,,1),tt,SUBSTITUTE(INDEX(tl,,2)&INDEX(tl,,3),$A$2,""),XLOOKUP(SEQUENCE(18),--tw,tt,"BYE "))"BYE " must be "BYE"
=LET(in,TRIM(CHOOSECOLS('Yearly Schedule'!A1:F273,1,4,6)),tl,FILTER(in,MMULT(--(in=$A$2),{0;1;1}),""),tw,TAKE(tl,,1),tt,SUBSTITUTE(INDEX(tl,,2)&INDEX(tl,,3),$A$2,""),XLOOKUP(SEQUENCE(18),--tw,tt,"BYE"))- Wrong column I need help with. I need help with column C
Enter the formula in C15 and then copy it down.
=IFERROR(IF(ISNUMBER(FIND("BYE",D15)),"",IF(VLOOKUP($A$2,INPUTSCORES,A15+1,FALSE)="","",VLOOKUP($A$2,INPUTSCORES,A15+1,FALSE))),"")
