Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In a spreadsheet in Google Spreadsheets, I’m trying to solve this:

17/02/2012  banana
17/02/2012  banana
17/02/2012  banana
17/02/2012  apple
18/02/2012  apple
18/02/2012  apple

I need a formula that returns how many times an unique value appears in a given date.


  • 17/02/2012 - two unique values
  • 18/02/2012 - one unique value

Can anyone help?

share|improve this question

migrated from superuser.com Sep 19 '12 at 14:51

This question came from our site for computer enthusiasts and power users.

I don't know how to create a formula, but you can insert a PivotTable to get the same results.

On the spreadsheet enter your data and include a heading for each column (so on your reference above you would add column headings: "date" and "value".

Then choose "Data ... PivotTable report" from the Menu. You are now working on a new tab which is the PivotTable and it references the data on your spreadsheet tab.

In the Report Editor on the right side of the screen make the following selections: "Rows - Add field" and choose "Date"; then choose "Values - Add field" and "Value" ... then "Display: Value, Summarized By "COUNTUNIQUE"

The PivotTable now shows you the unique entries for each date.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.