How to get the latest of row in google sheets

I want to get the last value of a specific column in Google Sheets. How can I do that?

Assuming the latest value is in the last row you can use search module and limit to 1 and sort by row number descending.