Find the three nearest dates
Hi,
This may be too simple, but what about temporarily sorting the data by the
date column. That would give you the three names at the top of the names
list. Then sort again by name to restore the data as it was.
Otherwise:
If your three cells that display the upcoming dates are in C24:C26, then in
B24 enter:
=INDEX($B$3:$B$19,MATCH(C24,$C$3:$C$19,0))
and copy down.
Regards - Dave.
|