I have written formula
IFERROR(INDEX(Table1,SMALL(IF(Table1[bank date]=F$6,ROW(Table1[bank date]),""),ROWS($6:6)),MATCH("book date",Table1,0)),"") but it does not work in sheet 2. I have tried my best to rectify but cant. F6 will be blank. Manually answers has also been narrated in sheet2. Attach with mail sample sheet.
I will be greatful to you for your help.
Bookmarks