Searching bulk terms

[ryangd2]

Hi, this's my first post here and I thought this'd be the best place to ask, if I have 6000 vaues in column B, and 200 values which are in column D, which are a part of the 6000. Is there any way to highlight these 200? I'm using excel '04. Thanks very much for any help.

 

[ryangd2]

Also, is there any way to show all entries that have a few similar consecutive letters? Like if there's a serial 182#####. I mean other than just searching "182" because there're probably tons of entries with similar serials. Basically any way to search for multiple prefixes?

 

[John Davis]

Hi, this's my first post here and I thought this'd be the best place to ask, if I have 6000 vaues in column B, and 200 values which are in column D, which are a part of the 6000. Is there any way to highlight these 200? I'm using excel '04. Thanks very much for any help.

In a separate Column to the right this formula copied down will flag those numbers. If you need something more elaborate let us know.

=IF(ISNA(VLOOKUP(D2,$B$2:$B$10,1,FALSE)),"",VLOOKUP(D2,$B$2:$B$10,1,FALSE))

 

[ryangd2]

In a separate Column to the right this formula copied down will flag those numbers. If you need something more elaborate let us know.

=IF(ISNA(VLOOKUP(D2,$B$2:$B$10,1,FALSE)),"",VLOOKUP(D2,$B$2:$B$10,1,FALSE))

Hey John, thanks that worked very well, could it work so that instead of printing the email that's in both columns beside b, it's just highlighted on the actual column B? This'd save time searching the database manually for each email that's in (new column for your formula) E.

Thanks for the help man.

 

[Robert Mika]

Question 1.
Highlight your D range, go to Conditional Formating (I hope you have in Excel 04), go to the place when you wil see "Use formula to determine..." and use this:
=COUNTIF($B$1:$B$100,D1)


Q2.
Use CF as well:

=VALUE(LEFT($D1,3))=$J$1

where J1 is the 182