Hello Friends
Please find the attached 2010 version file <Equal and nearest dates for 1 creteria170715.xlsx>
I want to find the Exact date, Nearest old and new date for the given input criteria (Letter) and given input date in Light yellow cells by formula.
thanks in advance
thilag
Finding the Exact date, Nearest old and new date for the given input date without criteria for reference.
http://www.excelforum.com/excel-form...iven-date.html
In F2
=IFERROR(INDEX($B$1:$B$12,MATCH(1,INDEX(($A$1:$A$12=$D2)*($B$1:$B$12=$E2),0),0)),"Nil")
In G2
=IF(MAX(IF(($A$1:$A$12=$D2)*($B$1:$B$12<$E2),$B$1:$B$12))=0,"Nil",MAX(IF(($A$1:$A$12=$D2)*($B$1:$B$12<$E2),$B$1:$B$12)))
Array entered
In H2
=IF(MIN(IF(($A$1:$A$12=$D2)*($B$1:$B$12>$E2),$B$1:$B$12))=0,"Nil",MIN(IF(($A$1:$A$12=$D2)*($B$1:$B$12>$E2),$B$1:$B$12)))
Array entered
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Hello Ace_XL
Excellent, thanks
thanks again
thilag
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks