return the earliest 'Next Date' of an asset

I have a worksheet (Office 365) where I need a formula to return the earliest 'Next Date' of an asset (Asset ID). In other words, if the asset id exist in a different row, then I want the earllest date next date of that particular asset. I tried the COUNTIF function (=IF(COUNTIF(B3:$B27,B3)>1,F4,""), but I don't think it's scalable as it makes reference to the next row, F4.

In my searching for a solution, I found folks are using IF INDEX, MATCH functions but they all utilize a helper column. If at all possible, I'd like the formula not to have these as my full sheet already is populated all the way to the BB column (see sheet2). In here the Disired Date is the 'Expected LES LB PM Exp date'

Any help is appreciated!

Hi hrlngrv,
I may be doing this wrong...it didn't work. What am I doing wrong? And how does "&current_date" work?

=INDEX(B3:B6,(MATCH(MINIFS(E3:E6,E3:E6,">"&3/13/2020),E3:E6,0)))

This produced 7/3/2025 and not the desired date.

The formula in column F (Desired Date) should look at column B (Asset ID), then, if the Asset ID is repeated in any row, then look at the 'Next Date' (column E) and get the earliest date (MIN) of the 2 rows. For example, in rows 3 and 4, the Asset ID of 43777 has 2 'Next Dates' values, 9/1/2020 and 6/6/2020, respectively. I want the formula (in column F) to search this asset ID in column B. If it finds the same value, then get the earliest date from column E. In this example, F3 and F4 should be 06/06/2020.

The 'Desired Date', column F should be:
F3 should be 6/06/2020
F4 should be 6/06/2020
F5 should be 02/18/2020
F6 should be 02/18/2020

I'm using your attached workbook from your original posting. That shows the following.

excel-forum-2020-03-13-d.png

Those dates differ from the dates you show in the screen fragment in #5. If you've updated the dates, update the sample workbook please. I charge for data entry, and I guarantee you can't afford my rate.

ADDED: If you just want the earliest date for each asset ID,

F3: =MINIFS(E$3:E$6,B$3:B$6,B3)

and fill down.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

I did it for you