Re: [libreoffice-users] Counting Instances

Hi Keith,

Keith Bates schrieb:
> Hi everyone,
>
> I've used Libre Office for years, but I am an absolute newbie as far as
> Calc is concerned for anything but the very basics. :)
>
> Here is my problem.
>
> My church has to report to the copyright licence holders the names of
> the songs it uses and the number of times each song is used in a given
> time period.
>
> The software we use for projecting the words for songs (OpenLP) will
> produce the name of each song used in each service. It will generate a CSV
>
> Obviously it is easy enough to import that into a spreadsheet.
>
> How can I then count the number of times each song is used? I could sort
> the table by song title and then count them manually, but I am guessing
> there would be some sort of function that automates the counting.
>
> Thanks for any help on this.

Import the csv data into the spreadsheet.
Define a data range for this data including the field names.
Generate a pivot table from it this way:
- drag the field name of the song title to the "Row Fields"
- drag the same field name to the "Data Fields".
- Double click the field name button in the "Data Fields" area and 
change the function from "sum" to "count".
OK

Using a pivot table has the advantage, that you do not need to know 
beforehand, which song titles are contained in the list.

Kind regards
Regina


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted