help with multiple criteria search across consolidated portfollio appraisal

[mena139]

Hello,

I was hoping for some help. I need to run a search across one excel sheet that contains information from 15 portfollios consolidated. in addition to searching by portfollio I need to search by security. lastly in addition to that I need to leave out a select few securities.

any and al lhelp is greatly appreciated.

 

[ranman256]

load the sheet into Access and run queries.