Someone at the google+ apps script forum suggested I ask you guys about this project I'm working on.  See the whole (pretty short) thread here: https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/docs/rpAFU0u7j7k/Y7bCGGzNDZMJ.In essence, I'm just trying to find a simple query that counts the entries of a particular name for this month and last month and outputs the number of times that entry shows up in that date range...Example: I'm trying to have sheet#2 (and others) poll sheet#1 to see what names have been entered and then aggregate the content.  example there are 3 separate entries for John Doe this month and 5 for last month, Jane Doe has 6 for this month and 2 for last month. Sheet#2 would then output, John Doe, 3 this month, 5 last month, Jane doe, 6 this month, 2 last month.  And rank them based on the number of entries.  Has anyone done anything like this?  Could someone give me some help?  Thanks so much!
Trying to query one sheet to inform another
google spreadsheets