0

Someone at the Google Docs Help Forum suggested I ask you guys about this project I'm working on. See the whole (pretty short) thread here.

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 three separate entries for John Doe this month and five for last month, Jane Doe has six for this month and two 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?

1

1 Answer 1

1

Does Sheet1 have the month, or just a date. If it doesn't have the month, can you make a helper column which contains the month.

Then from the Data menu, choose Pivot Table report.

Put Name into the Rows, and Month into the Columns (or vice versa), and then put Count of name into the values.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.