so if column A is filled and column B has only a few entries, you want the
last entry from column B (ie - all of the entries in column b are considered
later than the entries in column a)?

if so, try:
=IF(COUNT(B:B),LOOKUP(MAX(B:B)+1,B:B),LOOKUP(MAX(A :A)+1,A:A))


"computerwolf" wrote:

I am using Excel 2003.

I have two columns in which I enter the weight of individual rolls of
plastic...first down column A, then down column B. I'd like to have one cell,
say in column C, that reflects the last entry I made, no matter where it is
in columns A or B. Can this be done?