I have a time off calendar. What I would like for a column to do is count and update the number of unique values for that day.
Here is an example:
Day Off ||||| # of Values
12/1/13 ||||| 1
12/2/13 ||||| 3
12/2/13 ||||| 3
12/2/13 ||||| 3
12/4/13 ||||| 2
12/4/13 ||||| 2
So if you can see, I would like for the column to count the value provided in the “Day Off” column and count that value amongst the rest of the column.
Hope that makes sense and can this be done?