palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
Hello to all,
I have the following sheet, called ... Full School List ...
I have another sheet called ... Bradman ...
In BradmanB10 I have the following array formula ...
{=IFERROR(INDEX('Full School List'!$K$2:$K$2500, MATCH(0, COUNTIF(B$10:B10, 'Full School List'!$K$2:$K$2500)+IF('Full School List'!$F$2:$F$2500<>B$5, 1, 0)+IF('Full School List'!$S$2:$S$2500<>B$6, 1, 0), 0)),"")}
but as you can see in the image it's returning zeros, with the error message ...
The formula is meant to return the surnames of students (from column K in the 'Full School List' worksheet) who meet two conditions ...
1. they are in yr 7
2. they are female
When I evaluate the formula, i get down to the following final step ...
and it shows that the surname Adams is the first name that should appear in the list (as it has met both criteria), and this is correct, but it then goes and returns a zero.
Can anyone see where I've gone wrong ?
Kind regards,
Chris
I have the following sheet, called ... Full School List ...
I have another sheet called ... Bradman ...
In BradmanB10 I have the following array formula ...
{=IFERROR(INDEX('Full School List'!$K$2:$K$2500, MATCH(0, COUNTIF(B$10:B10, 'Full School List'!$K$2:$K$2500)+IF('Full School List'!$F$2:$F$2500<>B$5, 1, 0)+IF('Full School List'!$S$2:$S$2500<>B$6, 1, 0), 0)),"")}
but as you can see in the image it's returning zeros, with the error message ...
The formula is meant to return the surnames of students (from column K in the 'Full School List' worksheet) who meet two conditions ...
1. they are in yr 7
2. they are female
When I evaluate the formula, i get down to the following final step ...
and it shows that the surname Adams is the first name that should appear in the list (as it has met both criteria), and this is correct, but it then goes and returns a zero.
Can anyone see where I've gone wrong ?
Kind regards,
Chris