## Excel: Find last input value

*Article updated on August 07, 2007*

Problem: Find last input value in a column

Solution: =INDIRECT("A" & (COUNTA(A:A)))

Functions:

**INDIRECT(**ref_text;[a1]**)**

Returns the reference specified by a text string

**COUNTA(**value1;[value2]**;...)
**Counts the number of cells in a range that are not empty

This post explains how to lookup a value and return multiple values. No array formula required.

Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]

## Share this article