In a spreadsheet in Google Spreadsheets, Im trying to solve this:17/02/2012  banana17/02/2012  banana17/02/2012  banana17/02/2012  apple18/02/2012  apple18/02/2012  appleI need a formula that returns how many times an unique value appears in a given date.Example:17/02/2012 - two unique values18/02/2012 - one unique valueCan anyone help?
I need a formula that returns how many times a unique value appears in a given date
google spreadsheets