Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to count new users over the months?

  • Abid Khan
  • Topic Author
  • Offline
  • New Member
  • Nuovo membro
More
2 months 1 week ago #1488 by Abid Khan
How to count new users over the months? was created by Abid Khan
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

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo