Picking the list from data

[yshridhar]

Hello everybody. The following is my data

NO Sec English maths Science Social
1A1 1A 25 25 25 25
1A10 1A 25 25 24 25
1A11 1A 24 22 24 25
1A12 1A 25 25 23 24
1A13 1A 25 23 25 20
1B1 1B 20 24 23 22
1B10 1B 20 24 21 23
1B11 1B 20 18 22 23
1B12 1B 22 18 25 24
1B13 1B 20 18 23 23
1B14 1B 20 18 22 23
2A1 2A 23 23 25 24
2A10 2A 24 23 20 25
2A11 2A 24 22 24 25
2A12 2A 22 25 25 25
2A13 2A 24 25 23 25
2A14 2A 24 24 25 25
2A15 2A 22 25 25 24
2A16 2A 25 24 25 25
I want to list out the ID NO.s that satisfies the criteria based on the
values, B1=sec (1a/2b), C1=subject (maths) and D1=Mark less than a value
(say < 20). I am having the No. of pupil scored which satisfies the criteria
in E1. Can this be possible?
Thanks to you all in advance.
With regards
Sridhar

 

[Gary''s Student]

Consider using AutoFilter. You can set separate criteria on each of your
columns.

 

[yshridhar]

Thank you Mr. Gary's Student. But i want to extract the IDno.s in a separate
worksheet based onthe criteria. Can we give any cell values (say B1 or C1)
in Auto Filter.
With regards
Sridhar