I\u2019ve been giving the Excel Index that I developed last year a lot of use – mainly for the Memento Management \u00a0activity \u2013 and I\u2019ve decided that having just one column for Facet is not enough. Inevitably there are cases where you want to specify two facets (for example, Loughborough and Rugby) and this is easily done by just putting one after the other with a comma between in the single Excel cell. The trouble is that Excel\u2019s filter facility lists things alphabetically so, in the example above, if you look for Loughborough the entry \u201cLoughborough, Rugby\u201d appears in the appropriate position. However, if you are looking up \u201cRugby\u201d the \u201cLoughborough, Rugby\u201d entry does not appear in that position so you may miss that particular item related to Rugby.<\/p>\n
I\u2019ve addressed the problem by including a second column for Facet, and by including both entries in both columns but with one in reverse order to the other, for example, in Column 1 \u201cLoughborough, Rugby\u201d and in column 2 \u201cRugby, Loughborough\u201d. This ensures that, provided a search is done in both columns for a particular facet, you will find every instance of that facet and all secondary facets used with the facet being searched for.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" I\u2019ve been giving the Excel Index that I developed last year a lot of use – mainly for the Memento Management \u00a0activity \u2013 and I\u2019ve decided that having just one column for Facet is not enough. Inevitably there are cases … Continue reading