1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. 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

Discussion in 'Ask an Excel Question' started by JawaharPrem, May 19, 2017.

  1. JawaharPrem

    JawaharPrem Member

    Messages:
    86
    Hi All,

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

    Thanks
    Jawahar Prem

    Attached Files:

  2. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,577
    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.
  3. JawaharPrem

    JawaharPrem Member

    Messages:
    86
    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
  4. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,577
    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
  5. JawaharPrem

    JawaharPrem Member

    Messages:
    86
    Hi,
    Yes your correct,
  6. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,577
    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.

    Attached Files:

  7. JawaharPrem

    JawaharPrem Member

    Messages:
    86
    Hi Thanks for your time.
    for your understandin in uploaded this sample file. Please check and help on same.

    Thanks
    Jawahar Prem

    Attached Files:

  8. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,577
    See if attached meet your need.

    Attached Files:

    rcriceinc and JawaharPrem like this.
  9. JawaharPrem

    JawaharPrem Member

    Messages:
    86
    Hi Mr.Chihiro,

    wow it working your are ocean in excel great, thanks a log.

    Reagards
    Jawahar Prem

Share This Page