=IFERROR(INDEX(goooooooooo, SMALL(IF(FREQUENCY(IF(goooooooooo<>"", MATCH(ROW(goooooooooo), ROW(goooooooooo)), ""), MATCH(ROW(goooooooooo), ROW(goooooooooo)))>0, MATCH(ROW(goooooooooo), ROW(goooooooooo)), ""), ROW(A1)), COLUMN(A1)), "")


But this works ,

=IFERROR(INDEX(gooooooooo, SMALL(IF(FREQUENCY(IF(gooooooooo<>"", MATCH(ROW(gooooooooo), ROW(gooooooooo)), ""), MATCH(ROW(gooooooooo), ROW(gooooooooo)))>0, MATCH(ROW(gooooooooo), ROW(gooooooooo)), ""), ROW(A1)), COLUMN(A1)), "")


Do you know what might happen , while I press ctrl+shift+enter the first formula brings back blank , while the other brings back the right result . Each one refers to a different array of data