LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Finding the LAST value in a column

I'm not new to Excel, but so far I've only managed to deal with add,
subtract, multiply, and divide - in other words, nothing fancy. I now
find myself needing to learn a little more. I have a column which
contains a series of numbers. I add a new entry to this column each
week or so. I would like to always be able to to obtain the "last"
number in this column regardless of the column's length. I thought that
perhaps I might want to look for the first blank cell in the column and
back up one row to get the data, but perhaps that isn't the easiest way
to do it. Any suggestions or help any of you might offer would be
gratefully appreciated.

Thank you.
John O'Boyle
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding the same value in another column Richard Excel Worksheet Functions 0 April 24th 07 09:26 PM
Finding a number in a column out of an array in another column cirena Excel Discussion (Misc queries) 3 April 4th 07 06:30 PM
Finding max value in column A where value in B = [email protected] Excel Discussion (Misc queries) 4 April 3rd 07 12:02 AM
Finding Info from Column A and Removing it from Column B Johnny B[_2_] Excel Discussion (Misc queries) 2 March 28th 07 12:06 PM
Finding the closest number in column A and take the value in column B reefguy Excel Worksheet Functions 3 May 5th 06 07:25 PM


All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"