A little bit of an ILL Excel challenge
Posted by gazjjohnson on 23 August, 2010
I know there must be an elegant and clever solution to a problem I have. I’ve acquired an Excel output with a long list of values – 8,000+ to be exact. Each one is an instance when someone placed an interlibrary loan request last year for a book or a journal, and contains the title of a book or a journal. Like so:
|BOOKILL||Sharing the Earth: the Rhetoric of Sustainable Development||AC-STAFF|
|BOOKILL||Shelley and Vitality||RES-PG|
|BOOKILL||Shelley’s satire: violence, exhortation, and authority||RES-PG|
|BOOKILL||Shock, Memory and the Unconscious in Victorian Fiction||TC-PG|
|BOOKILL||Short Story Theory at a Crossroads||AC-STAFF|
What I want to know:
- Is there a way to group the list by most popular titles (e.g. those that appear more than once)?
You see in this way I can see books that are regularly requested for loan from the British Library , and likewise journals, that we could perhaps consider for purchasing. Something I’m sure the information librarians would find useful.
Using COUNTIF= has been suggested, but to use this I’d need to know what was the most popular variable already. I fear currently this goes beyond my Excel skills to solve, but I can’t be the first person to try and find this sort of information out. Any and all suggestions are welcomed – otherwise I’m going to have to eyeball this list.