Hey guys,
I was wondering if any of you Excel experts can help me out.
I am interning for a company and am compiling a database of more than a hundred companies. I would like to create an easily searchable database based on their attributes, such as their research methods, sectors covered, instruments covered, etc.
The autofiltering function would be the best to use in this case but I've come across a problem: I don't know how to group together various elements for each attribute. For example, if a company covers both Healthcare and Technology in their sectors, I have trouble in getting the autofilter drop down menu to correctly and neatly filter out the appropriate companies.
It's a bit hard to describe but the problem should be very clear once looking at the file I attached. Click Sector Covered on the dropdown menu, then Automotives and you'll see how Excel can't fully detect the correct company. Of course, I can do all the various combinations required to get the right company, but I would have to do that for 110 companies and it would be far too much work.
I've looked into using Microsoft Access but I'm unfamiliar with SQL. If there are any ways to bypass this through Excel, that would be ideal. Any links or advice would be much appreciated.
Thank you in advance.
Bookmarks