[SOLVED] [libreoffice-users] Counting Instances

On 30/12/13 09:51, 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

Thank you to everyone who offered help with this.

I found the pivot table option to be the best one- thanks Regina for 
your detailed instructions.

Before today, I had no idea what  a pivot table is- now apparently I can 
use one :)

I might read the user guide now to  deepen my understanding.

Paul suggested using Subtotals on the column with the song title, but I 
found this sorted just that column which separated the song titles from  
other fields. I guess I could have selected the other fields as part of 
the sorting/sub-totalling, but the pivot table has the advantage of 
giving the information without messing with the data.


--
God bless you
Keith Bates
4 Mooloobar St
Narrabri NSW
Ph 02 67924890

Jesus is the Way
the Truth and the Life


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