Excel 2003: Please help me create a search fu

Microsoft Office excel 2003
June 7, 2010 at 09:21:17
Specs: Windows XP

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?


Company 1 Company 2 Company 3 Company 4

I search for BBB and Company 1 and Company 4 are returned.


See More: Excel 2003: Please help me create a search fu

Report •

June 7, 2010 at 12:02:07
What is the formula you are using?



Report •

June 7, 2010 at 13:54:46
Sounds like you could transpose the data to columns insteaed of rows (sould use transpose feature to do this).

Title A1 with "Company" and B1 with "Credit Rating" where company1 is in A2 and the credit rating start in B2.

Company Credit Rating
Company1 BBB
Company2 A-
Company3 BBB-
Company4 BBB

Then use the data filter to filter all of column A and B.

Selecting the dropdown on column B's filter, select the text filter and enter criteria where column B contains BBB.

Should return you Companies 1, 3 and 4

Report •

Related Solutions

Ask Question