Finding Data Shortcut

[ang.ru]

Say I have a bunch of numbers that I want to find in my excel spreadsheet, like the following;


27001407

27001436

27001438

27001439

27001440

27001464

27001544

27001545

27001547

27001548

27001549

27001564

27001570


Is there anyway for excel to find all these for me at once instead of me searching for each number individually?

Thanks!

 

[Hui]

Ang.Ru


Not using Find


You could possibly use an Advanced Filter to extract the data

 

[ang.ru]

Thanks Hui!

 

[bobhc]

Good day ang.ru


Can you turn your data in to a table, if so you can select what numbers to show.

 

[Hui]

Note to self: I should use Table more !

 

[jeffreyweir]

Hui: Ctrl + T is your friend! ;-)