+ Reply to Thread
Results 1 to 8 of 8

Check for dublicate data in a list, if found then substract earliest date from the latest

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    Tallinn, Estonia
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    42

    Check for dublicate data in a list, if found then substract earliest date from the latest

    Hello,

    I'm looking for a function to calculate the average time for a RTC to travel from loading back to loading:
    In the sheet i have a list of RTC's (column B) and in column A the date it was loaded.
    In the column B the RTC number will be repeating, as one RTC will be reloaded on the terminal.
    I created a small scheme underneath the text, what has to explain what i need. I need to subtract the date A3 - A. Not sure if the scheme is understandable.

    Also the data can be repeating more than once.

    A list wit data is attached. Also one example of a duplicate value is marked as red. Please note that the loading dates are different.

    RTC no. 54670161:

    A(loaded 6.05.2012 23:30:00)------>B
    B1----->A2
    A3(loaded 24.05 02:00)----->B3
    Attached Files Attached Files
    Last edited by studio52; 06-05-2012 at 03:54 AM.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Check for dublicate data in a list, if found then substract earliest date from the lat

    Hi Studio52,

    See the data in column C,D,E.. and let me know if this the subtraction you are looking for...

    If you confirm, then I'll try to obtain the same using formulas. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    02-09-2010
    Location
    Tallinn, Estonia
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    42

    Re: Check for dublicate data in a list, if found then substract earliest date from the lat

    Hello DILIPandey,

    You forgot to attach the file

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Check for dublicate data in a list, if found then substract earliest date from the lat

    Oopss.. reattaching
    Book1(19).xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    02-09-2010
    Location
    Tallinn, Estonia
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    42

    Re: Check for dublicate data in a list, if found then substract earliest date from the lat

    Yes, this is exactly what i need. But there is a criteria i would like to add. That one and the same RTC can figure in the list many times. So it would be good that it would count always the newest date anterd in the bottom of the list withe the previous date(not the first in the for the RTC).

    Thank you for your effort!

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Check for dublicate data in a list, if found then substract earliest date from the lat

    Hi Studios52,


    See the attached file and let me know if this helps. thanks.
    Book1(19).xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  7. #7
    Registered User
    Join Date
    02-09-2010
    Location
    Tallinn, Estonia
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    42

    Re: Check for dublicate data in a list, if found then substract earliest date from the lat

    Dear DILIPandey,

    I don't know how to thank you! It works and its amazing! Unfortunately I can't give you more than one star.

    Thank you very very much!

  8. #8
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Check for dublicate data in a list, if found then substract earliest date from the lat

    you are welcome ...

    Cheers

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1