Results 1 to 15 of 15

Difference between two dates for one unique value thats repeats itself

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2024
    Location
    UK
    MS-Off Ver
    365
    Posts
    54

    Difference between two dates for one unique value thats repeats itself

    Hello everyone, my goal is a formula if S2 (and following values in S) matches any value in column B, then give me the difference in years and months from T2 and matching cell from column L belong to the matching value in B

    The B column values are all from the same unique ID that have procedures in different dates. The idea is to get years and months since they've joined (column T) in all the different procedures. So say in the example I've done 1111 which joined on the 09/04/2018 is 5y and 8 months on the procedure dated 18/12/2023. It would be 5y and 6 months for the previous procedure on the 18/10/2023

    So each value on S only has one unique date of joining (column T) but have different or equal procedures dates. Do let me know if I didn't explained correctly.

    Do let me know if I haven't explained correctly or if you need any more information

    Thanks!

    Test11.xlsx
    Last edited by ExcelNewbie92; 03-02-2024 at 05:03 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-08-2023, 05:50 PM
  2. Replies: 2
    Last Post: 07-26-2020, 04:50 PM
  3. Extracting a unique list from cells with a lot of repeats
    By hobofromdowntown in forum Excel General
    Replies: 4
    Last Post: 10-30-2019, 03:27 PM
  4. [SOLVED] How to calculate date difference between two dates with its related unique ID.
    By JayeshG in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-27-2018, 12:55 PM
  5. [SOLVED] Create unique array from columns with multiple repeats
    By BRISBANEBOB in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2017, 09:10 PM
  6. [SOLVED] Column Z difference for repeats
    By Jim Em in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2014, 09:45 AM
  7. Replies: 4
    Last Post: 01-26-2014, 05:48 PM

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