Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #102

Re: Last Value in Column

From Tavis Ormandy <taviso@gmail.com>
Newsgroups comp.apps.spreadsheets
Subject Re: Last Value in Column
Date 2025-04-12 20:01 +0000
Message-ID <m5vv5lF9qs5U1@mid.individual.net> (permalink)
References <MPG.4261d6bdcc2cd859896fe@news.eternal-september.org>

Show all headers | 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 | Next — Previous 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