How to search an excel spreadsheet ?

[Jack7122]

Hello,
If possible I would like to be able to search my spreadsheet in the same way as you can search the table on this website: http://www.datagrabber.org/family-fe...d-answer-list/

I would like to be able to type different parts of a row and have all the rows that have those parts show up.

Thanks

[MarvinP]

Hi Jack7122 and welcome to the forum,

This looks like a job for Advanced Filters to me.

See http://www.contextures.com/xladvfilter01.html for some examples.