Hi try these array formulas in the attachment
In E6
=IFERROR(LARGE(IF(TEXT(NIFTY!$B$2:$B$1400,"dd/mm/yyy")=TEXT($B$2,"dd/mm/yyy"),NIFTY!$E$2:$E$1400),1),"")
In E7
=IFERROR(SMALL(IF(TEXT(NIFTY!$B$2:$B$1400,"dd/mm/yyy")=TEXT($B$2,"dd/mm/yyy"),NIFTY!$E$2:$E$1400),1),"")
then in B6
=IFERROR(INDEX(NIFTY!B$2:B$1400,MATCH(1,(NIFTY!$E$2:$E$1400=$E6)*(TEXT(NIFTY!$B$2:$B$1400,"dd/mm/yyy")=TEXT($B$2,"dd/mm/yyy")),0)),"")
As for other cells just copy the formula in B6 and select other cells (B7 - C6:D7 - F6:G7) and right click then paste special and select formulas
Bookmarks