Groups | Search | Server Info | Login | Register


Groups > comp.apps.spreadsheets > #102

Re: Last Value in Column

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> (permalink)
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

Show key headers only | View raw


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

Back to comp.apps.spreadsheets | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

Last Value in Column Mike Copeland <mrc2323@cox.net> - 2025-04-10 13:23 -0700
  Re: Last Value in Column Tavis Ormandy <taviso@gmail.com> - 2025-04-12 20:01 +0000
  Re: Last Value in Column Rocinante <rocinante@gmail.com> - 2025-04-21 09:45 -0400

csiph-web