OP: .. It works well; the only (and hopefully final) problem I run into is
that the page with all the dates and names is not always populated with data
all the way to the bottom because it is updated over time. The above formula
returns a #VALUE! error because it has blank cells in the array subtract
todays date. I have been trying to use ISERROR, ISBLANK, and ISNUMBER but
having issues with it.
Think ISNUMBER can be added as a front check to exclude null string: "" or
text returns within the dates source range
I got it up working with this revised rendition in B2, array-entered:
=INDEX(Sheet1!$B$3:$B$11,MATCH(MIN(IF(ISNUMBER(She et1!$C$3:$C$11),IF((Sheet1!$A$3:$A$11=$B$1)*(Sheet 1!$C$3:$C$11TODAY())*(Sheet1!$C$3:$C$11-TODAY())0,(Sheet1!$A$3:$A$11=$B$1)*(Sheet1!$C$3:$ C$11TODAY())*(Sheet1!$C$3:$C$11-TODAY())))),IF(ISNUMBER(Sheet1!$C$3:$C$11),IF((She et1!$A$3:$A$11=$B$1)*(Sheet1!$C$3:$C$11TODAY())*( Sheet1!$C$3:$C$11-TODAY())0,(Sheet1!$A$3:$A$11=$B$1)*(Sheet1!$C$3:$ C$11TODAY())*(Sheet1!$C$3:$C$11-TODAY()))),0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---