To find the last cell in the column having only numbers, and no error values, use

=MATCH(MAX(A$1:A$1000),A$1:A$1000,1)

OR

=MATCH(9E+306,A$1:A$1000,1)