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
Frank FreeseAsked:
Who is Participating?
 
mvidasConnect With a Mentor Commented:
fh_freese,

Technically, your cell A1 is not empty, as it says "Find the Last Number in a Column". Your J1 cell is empty though, since "Practice" is in H1.

Since J1 is blank, change the countblank range to start in row 1 instead of row 3.

Matt
0
 
John EastonConnect With a Mentor DirectorCommented:
The reason the first formula works, and the second one doesn't is due to the merged cells.  The Cell A1 has a value, the cell J1 doesn't.  This is because the data for a merged cell is stored in the first cell of the merged area.

If you adjust the merged cell and put data in cell J1 both formula work the same.
0
 
Frank FreeseAuthor Commented:
Thanks folks. I can now see my problem!
0
 
Patrick MatthewsCommented:
BTW, if you want the last number in a column, you can make your formula much simpler:

=LOOKUP(10^200,A:A)
0
 
Frank FreeseAuthor Commented:
great tip! thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.