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: 3,101
Default Return Value of last cell in column with a value in Excel?

Is there an Excel funtion that calls the last value in a column? For example
I have a column that will be continuosly added to (through barcode scan) and
I need the last value in that column to show up in a specific cell. It sounds
so simple. there has to be a built in function, is there not? And if not can
someone help me with the code? (I don't know VBA too well, but understand the
logic)

Thanks.
 
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
Return next non-Blank Cell in a Column ? Jakobshavn Isbrae Excel Worksheet Functions 3 May 23rd 07 10:28 PM
Find a value in a table and return the cell or column reference jgrout Excel Discussion (Misc queries) 3 February 6th 07 06:21 AM
Return entry in column above/below cell TheRobsterUK Excel Worksheet Functions 2 November 17th 05 03:34 PM
Return activie cell indicator to column A next row down. Dewayne Excel Discussion (Misc queries) 6 October 28th 05 06:59 AM
return cell reference from any column Pirjo Excel Worksheet Functions 2 September 9th 05 06:11 AM


All times are GMT +1. The time now is 06:00 PM.

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

About Us

"It's about Microsoft Excel"