Need help generating list between two values

[Rosie63]

Trying to generate a list of names that fall within an attendance rate for school, say between 20% and 60% attendance. I can generate the list for amount less than or greater than but need to generate a list between two values. I am currently working with the following formula

=IFERROR(INDEX($A$2:$A$75,SMALL(IF($C$2:$C$75<60,ROW($A$2:$A$75)-ROW($C$2)+1),ROWS($C$2:$C2))),"")

The red section is the part that needs to be edited to include a greater than 20. I have tried incorporating 'AND' function but without luck.

Any help much appreciated

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this the sort of thing you mean?

23 05 08.xlsm
	A	B	C	D	E
1
2	Name 1		66		Name 2
3	Name 2		36		Name 3
4	Name 3		27		Name 7
5	Name 4		9		Name 10
6	Name 5		82		Name 11
7	Name 6		63		Name 14
8	Name 7		42
9	Name 8		93
10	Name 9		76
11	Name 10		52
12	Name 11		50
13	Name 12		4
14	Name 13		64
15	Name 14		25
16	Name 15		76
17
Attendance

Cell Formulas
Range	Formula
E2:E7	E2	=FILTER(A2:A75,(C2:C75<60)*(C2:C75>20),"")
Dynamic array formulas.