Thread: find cell address that meets the criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tkraju via OfficeKB.com tkraju via OfficeKB.com is offline
external usenet poster
  
Posts: 109
Default find cell address that meets the criteria
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

Reply With QuoteReply With Quote