Pulling data from a list

[thermometer]

Tough problem. I have a list of 40 records in one column, each with
different data, but with the same field headings (100, 245, 260, etc.)
that looks something like this:
100 Joe Smith
245 Book of home repair
260 Simon and Shuster
440 Language tape
500 Audio File
655 Audiobook
856 Bibliographic record URL
994 Location designation

If I only want to view certain fileds, like 100 and 245, how can I
extract that data from all the records and create a new table with that
information?
Thanks for any assistance.

 

[Gary''s Student]

There is an Excel feature called Autofilter that does exactly what you want:

1. make sure there is a label or header on top of the column of data:
id
100
245


2. click on the cell with the label and pull-down:
Data > Filter > Autofilter and you will have you feature.

 

[Ardus Petus]

Use Data>Filter>Advanced Filter

See example: http://cjoint.com/?fAqcB68hXc

Cheers,

 

[thermometer]

Maybe I wasn't completely clear. What I need as results should be each
record with the specific fields such as:
100 Joe Smith
245 Book of home repair
500 Audio File

100 Mary Jones
245 Cooking light
500 Large Print

100 Mary Carson
245 Math made easy
500 Paperback

etc.

 

[thermometer]

Ahhh, I got it. Thanks very much.