Excel: Excel FORMULA: count average of duplicates!!!


Hello folks, I’m struggling with a formula. Here is the situation: I have a list of entries with a date and I want to calculate for each date how many entries I have. Then, at final, know the average of entries that I have per day. At first looks simple but I am struggling so bad.. Example: Entry 1 - 12/10/2014 Entry 2 - 12/10/2014 Entry 3 - 13/10/2014 Entry 4 - 13/10/2014 Entry 5 - 14/10/2014 As a result, I want to see in a cell: 1,66666 that is the average of entries per same day. Thanks in advance! Sam


This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of October 26, 2014.


For more resources for Microsoft Excel