| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting the last cell value in a column
Heloo if i have 1 and it is so long say may be more than 1000 rows 1 2 3 453 566 4465 352 2 3434 how can i get the last number in it?? although each cell is a formual not blank -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=487323 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
getting the last cell value in a column
Since there can be alternatives in what you want check this website:
http://www.xldynamic.com/source/xld.LastValue.html Does that help? *********** Regards, Ron "amrezzat" wrote: Heloo if i have 1 and it is so long say may be more than 1000 rows 1 2 3 453 566 4465 352 2 3434 how can i get the last number in it?? although each cell is a formual not blank -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=487323 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| Copy one cell to entire column | Excel Discussion (Misc queries) | |||
Linear Mode
