How to create list based on data from another list

[danham]

Hi, I need this for a school project. I belive it's very basic, but I
can't understand what do I have to do, so if anyone could help me
please.

example of the list:

NAME MEMBERSHIP PRICE
xx yes 100
yy no 150
zz yes 100

(this list goes on)

now I have to create another list which will contain (show) only data
of the people who has YES in the membership column. I've searched the
net for the answers and what I found is that I should choose LIST
option from the DATA menu and do something there, but I don't have LIST
option in data menu (I'm using EXCEL 2002).

Thank you.

 

[Guest]

Hi

One way is to use Data/Filter/AutoFilter. You can then select 'yes' from the
dropdown and away you go!

Andy.

 

[danham]

Thanks Andy, well I hope that is what is asked in this exercise.

 

[sfby]

Try Data>Filter>Advanced Filter. It gives you the option of copying the
data that meets your criteria to another location (e.g a separate
worksheet).

Rgds

pnc1962