I have a spreadsheet with a column of names and column of dates. The column of names have duplicate names for same dates. I need to count how many names were on a certain date but my pivot table only sums the name column. I there a way to count the individual names that appear for each date...