create list box in MS Excel

Status
Not open for further replies.

Pragadheesh

In the zone
hi,
Consider i have a Coulmn, 'Grade' which can be A,B,C,D and F and list of students and other field.
Now i need to create a list box for the grades. i.e if i select grade A from the list box only the students with grade A should be listed and if i select grade B from the list box only the students with grade B should be listed etc.

How can i do this,.??
I tried something with Data->Validation and selecting List, still I'm unable to get what i need.
So how can i do it.?
Thanks in advance.
 

yogeshm.007

The real Bond
Data > Filter > Auto Filter should do for you...
You'll have to have your data like this:
Grade - Name - Marks (header row)
Grade A - student name - number
Grade A - student name - number
Grade B - student name - number
Grade A - student name - number
Grade C - student name - number
 
Status
Not open for further replies.
Top Bottom