Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #103

Re: Last Value in Column

Show all headers | View raw

On 4/10/2025 4:23 PM, Mike Copeland wrote:
> 
>     How can I find the last value in a column?  For example, here is a
> column of values in a workbook:
> 
> 3,324.51
> 3,247.20
> 3,219.54
> 3,155.69
> 3,144.84
> 3,111.34
> 3,055.96
> 2,994.24
> 2,987.20
> 
>     What Excel function/formula will show "2,987.20" (the last value in
> the column)?  TIA
> 
> 
If you are using VBA, something like this will work:

Cells(Rows.Count, "A").End(xlUp).Value

Back to comp.apps.spreadsheets | Previous | Next — Previous 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