find last item in a row in a Google Sheet

Posted on by Joel D Canfield

=index(A1:n1;1;counta(A1:n1))

where n is the last column to contain any data