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 |
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 |
All times are GMT +1. The time now is 02:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com