Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 03, 2016, 05:28:09 AM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: sort and filter  (Read 474 times)

techidave

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,012
    • View Profile
    • Donate to Member
sort and filter
« on: January 14, 2016, 09:51:23 AM »
I am looking for a way to sort and filter items in a spreadsheet or maybe in a database.  What I am wanting to do is keep track of songs sung in church, how many times it was sung and what date(s) they were sung.  I will have a date in a row with the songs under it.  Then 7 days later will be another list of songs under the date.  Maybe something like this:

Jan 1
song a
song b
song c
jan8
song a
song d
song e
song c
and so on

now I can do this in a pivot table function in Excel 2010.  But I do not know how to keep jan1 and jan8 from showing.  Then I would have to delete those rows.

I am not familiar with databases at all.  I am looking for suggestions how I can make this work easliy.

Ideas?

Dave

Target

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,605
    • View Profile
    • Donate to Member
Re: sort and filter
« Reply #1 on: January 14, 2016, 04:31:19 PM »
split it into 2 columns, ie DATE | SONG, then your pivot should be able to show the dates across the top, and songs down the left (use a count function)