Last Item in Column
Is there a way to find the last item in a column of numbers and put
that into a different cell at the top of your spreadsheet? Thanks |
Last Item in Column
If you want to do it by formula:
http://www.dailydoseofexcel.com/arch...he-last-value/ if you want it with VBA: http://j-walk.com/ss/excel/tips/tip30.htm Google is your friend :) hth Carlo On Dec 19, 4:12 pm, Peter wrote: Is there a way to find the last item in a column of numbers and put that into a different cell at the top of your spreadsheet? Thanks |
Last Item in Column
=LOOKUP(10^10,J:J)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Peter" wrote in message ... Is there a way to find the last item in a column of numbers and put that into a different cell at the top of your spreadsheet? Thanks |
Last Item in Column
Hey that is pretty slick, thanks.
On Wed, 19 Dec 2007 09:44:05 -0000, "Bob Phillips" wrote: =LOOKUP(10^10,J:J) |
All times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com