Excel Help

[Donna]

I am trying to find 300 numbers in a file that contains over 5,000 numbers in
one column. How can I separate these 300 numbers from the other 4,700 that I
do not want? Is there a way to do this (other than manually looking each one
up)?

Thanks for your help.

 

[Bill Foley]

You are in the wrong NewsGroup (PowerPoint), but you can click "Data",
"Filter", "AutoFilter" and your top column (usually field names) will have
dropdown arrows. If you click the desired column dropdown each of the items
contained in that column will appear. Select the one you want and all
records will be filtered out. When done, click the dropdown and click
"All".

 

[Michael Koerner]

You landed in the PowerPoint newsgroup. you might want to ask in the Excel
newsgroup.

--
<>Please post all follow-up questions/replies to the newsgroup<>
<><>Email unless specifically requested will not be opened<><>
<><><>Do Provide The Version Of PowerPoint You Are Using<><><>
<><><>Do Not Post Attachments In This Newsgroup<><><>
Michael Koerner [MS PPT MVP]


|I am trying to find 300 numbers in a file that contains over 5,000 numbers
in
| one column. How can I separate these 300 numbers from the other 4,700
that I
| do not want? Is there a way to do this (other than manually looking each
one
| up)?
|
| Thanks for your help.