In case there never will be several rows with same minimum number on same earliest date, this will work. You need a helper column (which you can hide). The result is calculated by Named Value (from Formulas menu, activate Name Manager to see it), and instead row number (which would need an additional helper column), it returns the date of minimum value.

When there is the possibility having several (n) rows with same date (the result of current Named Value will be MinDate*n then), then you have to modify Named Value formula - you have to count such records, and divide current formula with result of count.

Attached Files

MinValueDate.xlsx (10.9 KB, 11 views)