Calculated Column - # of Unique Values Within Column

Question

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?

Answer 1

Calculated columns only work with data in the same item. You cannot do SUMs or other calculations that require data from other items in the list.

You could, however, accomplish what you are looking for by using the Grouping options in your view of the list. You can group by the date and then you will get a count of the items in that group.