• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to find Repeat numbers with 24 hours

Hi All,

provide the numbers and creation date, in that how to find repeted numbers with in 24 hours.

Thanks
Jawahar Prem
 

Attachments

  • help.xlsb
    10 KB · Views: 2
Can you define what's considered within 24 hours?
Is it within same date or can it cross over into next day (but within 24 hour period).

Also, which columns are to be considered SR # or Customer Cell #?

I'd suggest manually fill expected output in the sample so we can validate solution.
 
Hi Thanks your response Mr.Chihiro,
Please consider "Customer cell" time consider the 24 hours,

the logic is the same "customer cell number" repet with 24 hours by time
 
Ok, then for below what should be returned for each line?
Do you consider only the 24 hour window after the creation datetime?

SR NUMBER CUSTOMER CELL NUMBER CREATION DATE REP
657394910 7020045713 4/5/2017 16:23
660883730 7020045713 4/5/2017 15:20
245406072 7020045713 4/5/2017 21:02
 
See attached.

I'm still a bit confused about what you are trying to get as output. If attached isn't it, then manually create expected output to demonstrate.
 

Attachments

  • help.xlsb
    10.8 KB · Views: 2
Hi Thanks for your time.
for your understandin in uploaded this sample file. Please check and help on same.

Thanks
Jawahar Prem
 

Attachments

  • test.xlsb
    9.2 KB · Views: 2
Back
Top