Basic Query

[KiwiBrian]

Assume that I have a large taxonomic list of animals.
Column A is the common name.
Columns B to G contain the appropriate Kingdom, Phylum, Class, Order,
Family, Genus.
What Excel facility do I research to ascertain how to extract a list of all
rows belonging to a specific classification that I specify from Columns B to
G?
E.g. a list of all arachnids.

Thanks for any pointers
Brian Tozer

 

[tina]

Excel facility? if this is an Excel file you're describing, suggest you post
your question in an Excel newsgroup. this newsgroup pertains to MS Access
relational database software.