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.

--
Gary's Student


"thermometer" wrote:

> 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.
>
>

[Ardus Petus]

Use Data>Filter>Advanced Filter

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

Cheers,
--
AP


"thermometer" <[email protected]> a écrit dans le message de news:
[email protected]...
> 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.
>

[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.