Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Picking the list from data
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Picking the list from data
Consider using AutoFilter. You can set separate criteria on each of your
columns. -- Gary''s Student - gsnu200755 "yshridhar" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Picking the list from data
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 "Gary''s Student" wrote: Consider using AutoFilter. You can set separate criteria on each of your columns. -- Gary''s Student - gsnu200755 "yshridhar" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Picking every monday from a list of dates | Excel Discussion (Misc queries) | |||
how do i sort a list from cells by picking a specific letter? | Excel Discussion (Misc queries) | |||
Picking values out | Excel Worksheet Functions | |||
Picking Values from a list | Excel Worksheet Functions | |||
Picking data | Excel Worksheet Functions |