Searchable tags in Excel?
- by Dustin Sanders
I'm building a database of spiders, organizing them by name, country, and region within that country.
The problem is that many of the spiders exist in multiple countries and regions within that country.
I want to be able to sort spiders by either country, or region, without having to enter a duplicate entry for every country or region that spider exists in.
For example: Say Spider A exists in the USA and Australia. In the USA it lives in the South and North West. In Australia it lives in New South Wales.
Is there a way I can make one entry for this spider, but tag it so it will show up when I search for spiders in USASouth or AustraliaNew South Wales?