=SUMPRODUCT(MAX((ROW(A1:A65535))*(A1:A65535<""))) +(A65536<"")

will tell you where the last value is, number or not.
--
Gary''s Student - gsnu200909


"jcheko" wrote:

need to figure a function that identifies the last cell with a value (could
be a number or a letter) in a column....I will be updating this every other
day, it should be able to identify the next cell if I add a value to the
column. for your help I am very thankfull.