Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 13 March 2019
  0 Replies
  2.7K Visits
0
Votes
Undo
Hi,

I have a table which has two columns. First column has "DD-MM-YYYY" and other has "Mobile Numbers". This data starts from 1-Jan-2018 and goes upto 30-Dec-2019.


I want to find out the new users per date or month. It should not count the second or 3rd or so on occurrence of the user. The whole purpose is to see the adaption rate of new users.



Sample Data


Date Mobile Number
01/02/2019 11111111
01/02/2019 22222222
01/02/2019 11111111
01/02/2019 33333333
01/02/2019 44444444
02/02/2019 55555555
02/02/2019 11111111
02/02/2019 22222222
02/02/2019 66666666
02/02/2019 77777777
03/02/2019 44444444
03/02/2019 66666666
03/02/2019 77777777
03/02/2019 88888888

Result Required

Date Cell Number
01/02/2019 4
02/02/2019 3
03/02/2019 1

Your support will be much appreciated.

Regards,
Abid Khan
There are no replies made for this post yet.