Excel 2012 - Formula to find the last cell with data and return row #

[Johnny Thunder]

Hello all,


I need help with a formula that looks in row A and finds the last cell with data and returns the cell number once found. Thanks for your help!

 

[kevin lazell]

hi johnny thunder

try
=COUNTIF(A1:A1000,">""")
or
=COUNTIF(A1:z1,">""")
you refered to row a in your post
rows are numbered and columns are lettered
so not sure which one you want
cheers
kevin

 

[BenMiller]

Hello all,


I need help with a formula that looks in row A and finds the last cell with data and returns the cell number once found. Thanks for your help!

Will your data be numbers, text, or both?

 

[Johnny Thunder]

Actually I am glad you asked. The data is dates and when I used the formula that was given in the first comment it did not return the correct row number. Were almost there!

Thanks again everyone for your help! I love this site!

 

[BenMiller]

try =MATCH(9.9E+307,1:1,1)

 

[Johnny Thunder]

That formula is looking to row 1 and counting columns. I need it to look down and count rows. Can you manipulate the formula to do this? Thanks again!

 

[BenMiller]

=match(9.9e+307,a:a,1)

 

[Johnny Thunder]

Perfect!!!

Thanks Ben!!

 

[BenMiller]

Perfect!!!

Thanks Ben!!

No problem Glad I could help Appreciate the feedback!