Problem with finding last number in a column
Folks,
I have attached a workbook where I am trying to identify the last number used in a column. There are two examples. The first one works, but the second one under the Practice section does not give me the correct answer and I do not know why.
LastNumberColumn.xlsx
I have attached a workbook where I am trying to identify the last number used in a column. There are two examples. The first one works, but the second one under the Practice section does not give me the correct answer and I do not know why.
LastNumberColumn.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
BTW, if you want the last number in a column, you can make your formula much simpler:
=LOOKUP(10^200,A:A)
=LOOKUP(10^200,A:A)
ASKER
great tip! thank you
ASKER