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.
Example:
- 17/02/2012 - two unique values
- 18/02/2012 - one unique value
Can anyone help?