Re: [SOLVED] [libreoffice-users] Counting Instances

2013-12-30 Thread Paul
On Mon, 30 Dec 2013 17:47:54 +1100 Keith Bates ke...@new-life.org.au wrote: 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

[libreoffice-users] Counting Instances

2013-12-29 Thread Keith Bates
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

Re: [libreoffice-users] Counting Instances

2013-12-29 Thread Jay Lozier
On 12/29/2013 03:12 PM, Keith Bates wrote: 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

Re: [libreoffice-users] Counting Instances

2013-12-29 Thread doug
On 12/29/2013 05:10 PM, Jay Lozier wrote: On 12/29/2013 03:12 PM, Keith Bates wrote: 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

Re: [libreoffice-users] Counting Instances

2013-12-29 Thread Regina Henschel
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

Re: [libreoffice-users] Counting Instances

2013-12-29 Thread Jay Lozier
On 12/29/2013 05:47 PM, doug wrote: On 12/29/2013 05:10 PM, Jay Lozier wrote: On 12/29/2013 03:12 PM, Keith Bates wrote: 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

Re: [libreoffice-users] Counting Instances

2013-12-29 Thread Carl Paulsen
+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

Re: [libreoffice-users] Counting Instances

2013-12-29 Thread Keith Bates
On 30/12/13 09:47, doug wrote: On 12/29/2013 05:10 PM, Jay Lozier wrote: On 12/29/2013 03:12 PM, Keith Bates wrote: 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

Re: [libreoffice-users] Counting Instances

2013-12-29 Thread Paul
Just as another option, you can also use Data | Subtotals, although I think a pivot table is probably nicer looking. Let's say you have a simple list of song names in column A. For some reason this operation seems to expect a header row, and I didn't see an option not to use one, so make sure you

[SOLVED] [libreoffice-users] Counting Instances

2013-12-29 Thread Keith Bates
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