Microsoft Office Forums - View Single Post - We need to search for duplicate entries across 12 tabs and return 2 values of the most recent entry

SnakeDoctor · 03-03-2025, 10:13 AM

Hey everybody!

So, I'm on to another Workbook, this time tracking the release of versioned Task Cards by Month and Week (of the month).

Each Month has its own Tab, with Named Ranges for each Week (1-5) of that month.

The data we need to search through includes the Task Card Number, its Release Date, and the Version, and each data point has its own column.

What we need is a formula to search all previous Release Date entries, from 01/01/2025 until the date of this entry, for duplicate Task Card Number entries, and if found - return the most recent Release Date and Version of that Task Card entry in another two columns titled Last Release Date. (I haven't added this column yet!) Okay - this column has been added to EXAMPLE B)

For Example:

In the March tab we enter: Task Card Number - ABC123; Version - 3; Release Date 03/03/2025.

The last times this Task Card was released, was on 02/15/2025 Version - 2, and on 01/07/2025 Version - 1.

The formula needs to search for previous entries of Task Card ABC123 and, if found, populate the Release Date and Version, in this case 02/15/2025 Version - 2.

I have attached an example of the whole spreadsheet for reference.

Any ideas would be appreciated, I would prefer to avoid VBA if possible as this will be housed on a SharePoint site (out of my control) that does not allow VBA, Macros, etc. (yea, I know).

Thanks!