I'm a bot confused as to whether you mean rows or columns. The following formulas must be entered in a different row to where the data is entered.
To get the last numeric entry in row 1
To get the last text entry in row 1
If you actually meant columns not rows then
gets the last numeric entry in column C and
gets the last text entry.