Hi Gary's student

Thank you for the help. But I cannot get it to work?
I have tried entering what you wrote: =if(rows($1:1)<=counta($a$1:$a
$100),index($a$1:$a$100,small(if($a$1:$a$100<*"", row($a$1:$a$100)-min
(row($a$1:$a$100))+1),rows($1:1))),"")

in a cell but it gives me an error whenever I press enter and marks
the index part of the formula as if there is an error there?

Any suggestions what the error could be?