Data filtering

[ashani]

Hi team,

I wonder if someone could please guide me on data filtering option :

I have approx 80 telephone numbers and I have a list of data for approx 10,000 numbers - I would like to extract those 80 numbers full line from the list (80 telephone numbers could be there multiple times).

Any formula or VBA syntax would be fine.

Many thanks,

 

[ashani]

Perfect - thank you
It worked!!!

 

[Fluff]

What is the formula you are using?

 

[ashani]

same the one you provided and it worked.

 

[ashani]

is it possible to have a formula for all the numbers in criteria to show the name in any column. For example

Criteria is :
123 abc
321 cde
456 ads
789 qwe
654 cgf
123 bbb
654 aaa

I would like the names next to criteria appear somewhere, like if there's any if formula etc I can put in.

Thank you once again.

 

[Fluff]

same the one you provided and it worked.

Glad we could help & thanks for the feedback.

As this is a completely different question, it needs a new thread. Thanks

 

[ashani]

sure thank you once again