Home
Forum
Software
Mouser's Software
NANY: New Apps for the New Year
Friends of DC
Forum Coding Snacks
Editorials
Daily Blog
Monthly Newsletter
Mini Reviews
Favorite Websites
Archives
Articles
Historical Archives
Testimonials: What Folks Say About Us
Licensing
Get a License Key
Commercial Licensing
Help
Search
FAQs
DonationCoder Sitemap
Live Chat (Discord)
Contact Us
About Us
Donate
Home
Forum
Software
Mouser's Software
NANY: New Apps for the New Year
Friends of DC
Forum Coding Snacks
Editorials
Daily Blog
Monthly Newsletter
Mini Reviews
Favorite Websites
Archives
Articles
Historical Archives
Testimonials: What Folks Say About Us
Licensing
Get a License Key
Commercial Licensing
Help
Search
FAQs
DonationCoder Sitemap
Live Chat (Discord)
Contact Us
About Us
Donate
This topic
This board
Entire forum
Website and forum (google)
Member search
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
6 Months
Forever
Login with username, password and session length
Tuesday December 10, 2024, 3:11 pm
Proudly celebrating 15+ 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.
Forum Home
Search
Login
Register
Recent Topics
Go To..
Recently updated topics
Recent posts (compact)
Recent posts (full text)
DonationCoder.com Forum
»
Main Area and Open Discussion
»
Living Room
»
sort and filter
« previous
next »
New Topic
Print
Pages: [
1
] •
bottom
Author
Topic: sort and filter (Read 2636 times)
techidave
Supporting Member
Joined in 2007
Posts:
1,045
sort and filter
«
on:
January 14, 2016, 09:51 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,832
Re: sort and filter
«
Reply #1 on:
January 14, 2016, 04:31 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)
New Topic
Print
Pages: [
1
] •
top
« previous
next »
DonationCoder.com Forum
»
Main Area and Open Discussion
»
Living Room
»
sort and filter