Hi
I am trying to create a search function in excel. The data sheet has the company name in row 1 and the credit ratings in row 2. I want to see a list of all companies with a BBB rating. Please could someone help?
E.g.
Company 1 Company 2 Company 3 Company 4
BBB A- BBB+ BBB
I search for BBB and the names for Company 1 and Company 4 are returned. The data set has about 150 entries and will continue to grow and certain searches will return more than 10 entries.
Thanks
Bookmarks