Try this entered as an array formula ctrl + shift + enter
=INDEX(A1:A6,MATCH(MIN(IF(A1:A6-B1=0,A1:A6,FALSE)),IF(A1:A6-B1=0,A1:A6,FALSE),0))
"tkraju via OfficeKB.com" wrote:
Col a............... Col B
27-Aug-2005 ..................03-Mar-2006
10-Feb-2006
19-nov-2006
25-Jan-2007
I am looking for a function that gives cell address in range A1:A4 ,date that
is(nearest) greater than B1 date.
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1