Re: [libreoffice-users] Counting Instances

+1
That's how I'd do it.


On 12/29/13 5:51 PM, Regina Henschel wrote:
> 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

--

Carl Paulsen

8 Hamilton Street

Dover, NH 03820

(603) 749-2310


--
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