UoL Library Blog

Develop, debate, innovate.

Posts Tagged ‘data analysis’

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 Shipwreck Anthropology DL-TCPG
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.

Advertisements

Posted in Document Supply | Tagged: , , , , , | 9 Comments »