Number of unique date count


I have an excel sheet where I have two columns,

  1. Date
  2. Registration

Number of same date is being counted multiple time in my excel. I required to count number of registration in a single date.

Please help.

With Regards,
Sandip Paul

Hi all,

After multiple try I am able to do it with this code

aggregate(mydataframe$registration ~ mydataframe$date, mydataframe, sum)

Thanks all.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.