Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Tavis Ormandy <taviso@gmail.com>
Newsgroups: comp.apps.spreadsheets
Subject: Re: Last Value in Column
Date: 12 Apr 2025 20:01:57 GMT
Lines: 14
Message-ID: <m5vv5lF9qs5U1@mid.individual.net>
References: <MPG.4261d6bdcc2cd859896fe@news.eternal-september.org>
X-Trace: individual.net lIDDIaOnCHzfFqAV0MoksAti7AevV+puNUk8AnI2+ibVLMujoe
Cancel-Lock: sha1:kRCKoFfOkenDvDnV/qDDSLFyC/M= sha256:e2shMpwji0C77jUhNP36nu1cGZ4Ovr7Xfs9Yve+hRVw=
User-Agent: slrn/1.0.3 (Linux)
Xref: csiph.com comp.apps.spreadsheets:102

On 2025-04-10, Mike Copeland wrote:
>
>    How can I find the last value in a column?  For example, here is a 
> column of values in a workbook:
>

Try something like INDEX(X1:X10, COUNT(X1:X10))

Tavis.

-- 
 _o)            $ lynx lock.cmpxchg8b.com
 /\\  _o)  _o)  $ finger taviso@sdf.org
_\_V _( ) _( )  @taviso