Hope I can explain this without being too confusing!
I have a formula that works in ms excel but gets a #value! error, when there are 2 IF checks together.
What I’m trying to do is pick the top ranking scores in male female categories.
Here is a copy of my formula that works, except it does not select whether or not the person is male or female.
=IF(A37="","",INDEX($‘par équipe’.$B$2:$B$101,SMALL(IF($‘par équipe’.$C$2:$C$101=B37,ROW($‘par équipe’.$C$2:$C$101)-ROW($‘par équipe’.$C$2)+1),COUNTIF($B$7:B37,B37))))
This formula gives an error
=IF(A43="","",INDEX($‘par équipe’.$B$2:$B$101,SMALL(IF(IF($‘par équipe’.$A$2:$A$101=“m”,$‘par équipe’.$C$2:$C$101=B43),ROW($‘par équipe’.$C$2:$C$101)-ROW($‘par équipe’.$C$2)+1),COUNTIF($B$7:B43,B43))))
This is what it looks like in ms excel 2007
=IF(A37="","",INDEX(‘par équipe’!$B$2:$B$101,SMALL(IF(IF(‘par équipe’!$A$2:$A$101=“m”,‘par équipe’!$C$2:$C$101=B37),ROW(‘par équipe’!$C$2:$C$101)-ROW(‘par équipe’!$C$2)+1),COUNTIF($B$7:B37,B37))))
Hope you can help!!!
Ranger801