Lookup value with multiple entries and return smallest value

[ericaindallas]

I have a list of ID's with dates, the list of ID's have repeated entries, but some with different dates; I would like to show only the earliest date to my list of unique ID's.

Also blanks are involved and need to be indicated still as blank it there is not a date at all, BUT if there is a date(s) and blank(s) to the same ID, I need the earliest date and not the blank.

Here is just a small portion as an example. The highlighted piece is what I'd like a formula to produce (it's hard coded here).

Your help is appreciated.

Thanks,
Erica

 

[Robert Mika]

Array formula confirm CTRL+SHIFT+ENTER:

=IF(MIN(IF($A$2:$A$21=D2,$B$2:$B$21))=0,"",MIN(IF($A$2:$A$21=D2,$B$2:$B$21)))

 

[Aladin Akyurek]

Array formula confirm CTRL+SHIFT+ENTER:

=IF(MIN(IF($A$2:$A$21=D2,$B$2:$B$21))=0,"",MIN(IF($A$2:$A$21=D2,$B$2:$B$21)))

Not sure, but it might be a tad faster...

=MIN(IF(ISNUMBER($B$2:$B$21),IF($A$2:$A$21=D2,$B$2:$B$21)))

 

[T. Valko]

Array formula confirm CTRL+SHIFT+ENTER:

=IF(MIN(IF($A$2:$A$21=D2,$B$2:$B$21))=0,"",MIN(IF($A$2:$A$21=D2,$B$2:$B$21)))

Not sure, but it might be a tad faster...

=MIN(IF(ISNUMBER($B$2:$B$21),IF($A$2:$A$21=D2,$B$2:$B$21)))

Those are 2 different formulas.

One will return blank and one will return 0.

Can't compare apples to oranges.