Formula for Find out Last Value in an Excel Column Jafar Poovulla Parambath Updated on December 13, 2019October 7, 2024 Categories Blog, Excel, FORMULA No Responses This formula will help you in finding out the value in the last cell of a column. =LOOKUP(2,1/(ISNUMBER (C1:C100)) ,C1:C100) Share this:FacebookX Post navigation How to extract number only from a text in ExcelContingent Asset & Liability Author Jafar Poovulla Parambath Share This Story Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment * Name * Email * Website Save my name, email, and website in this browser for the next time I comment. Δ