Multiple Search in Excel, Access, or Word

[sparkyy192]

I have two columns of data lets call these columns A and B. I need to do a search in column B to find specific numbers. SO lets say column B has the numbers from 1 - 10 going down in 5 rows. How can I do a search and have it find the numbers, 1, 3, 7, and 5 for example.

Note, i need to do this on a much larger scale. In a column with about 13000 rows, i need to find about 3000 distinct entries.

Is this possible?

 

[ck1999]

Are you wanting to return the rows? What is the next step of the process?

Have you tried autofilter? in xl07 I know you can numerous filter choices per column

ck1999

 

[sparkyy192]

how do i do that?

Basically out of those 15000 entries, i need to highlight 3000 specific ones. Then find the corresponding number in column A and record those two together.

 

[AnotherHiggins]

-> lets say column B has the numbers from 1 - 10 going down in 5 rows
How do you have 10 numbers in only 5 cells (B1:B5)?

Please post an example of your current layout - just columns A & B and the type of data in each column is fine.

Also, are the 3000 specific entries listed on another sheet/workbook? If not, how will you determine what entries you want to display?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[ck1999]

Where do you want to record them to?

what version of xl do you have?

ck1999