=IFERROR(INDEX(OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),MATCH(TRUE,IF(FREQUENCY(MATCH(OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),0),MATCH(OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),0)),COUNTIF(OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),"<"&OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2)))=SMALL(IF(FREQUENCY(MATCH(OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),0),MATCH(OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),0)),COUNTIF(OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-2),"<"&OFFSET('Data set'!$I$3,0,0,COUNTA('Data set'!$I:$I)-1))),ROWS($1:1)),0)),"")
However, it returns blank because there are some blanks in the range I:I - if you add a value to the blank cells, it works. In other words, your dataset in column I needs to be complete for it to work. It will not work if there are blanks in that column.
Bookmarks