I’m using version 6, also have the same problem with version 5.
Here is the formula. {=IF(A7="","",INDEX($par_équipe.$B$5:$B$42,SMALL(IF(IF($par_équipe.$A$6:$A$43=“m”,$par_équipe.$C$5:$C$42=B7),ROW($par_équipe.$C$5:$C$42)-ROW($par_équipe.$C$5)+1),COUNTIF($B$7:B7,B7))))}
I think the problem is the two IF statements together. This works with excel.
Because this formula works (it does not have the double IF statement.
{=IF(Y7="","",INDEX($par_équipe.$B$5:$B$42,LARGE(IF($par_équipe.$E$5:$E$42=Z7,ROW($par_équipe.$E$5:$E$42)-ROW($par_équipe.$D$5)+1),COUNTIF($Z$7:Z7,Z7))))}
Looks like I need to modify my formula but I don’t know what to do.
Here is the complete spreadsheet. The excel file has no errors but the LO does, anywhere there are two IF statements together.
Go to the Calculate page, notice C7 has error, all other cells with same formula have this error. On the far right in column AA the formula is the same, except, there is no if reference to “m”.
Dards Stats 2017-2018 1803.07.ods
Dards Stats 2017-2018 1803.07.xlsx
HELP.
Hopefully, someone has an answer.