Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

last value in column

0

I'm trying to get the last figure (date) in column B to display in Cell D12

I used formula

=INDEX(A:A,COUNTA(A:A))but displays nothing 
I got this from tutorial on here
https://www.teachexcel.com/excel-tutorial/2073/formula-to-get-value-of-last-non-empty-cell-in-excel?nav=sim_side_col_forum#robust_formula_for_value_of_last_non_empty_cell

EDIT

This issue is solved thank you John

I have protected the sheet and workbook. just for looks. there is no password to unlock it

excelfinanceformulas-functions
MS Office Version: 2019
posted by: wildecoyote1966 (rep: 30) on Sat Sep 25, 2021 at 10:39 am
Answer
Discuss

Discussion

Which of Don's tutorials was it? Please add a LINK to your question
John_Ru (rep: 6142) Sep 25, '21 at 11:19 am
Add to Discussion

Answers

0
Selected Answer

Albert

Given you have a series of sequential dates in columns B, just use:

=MAX(B:B)
in cell D12 and format that cell as a date.
posted by: John_Ru (rep: 6142) on Sat Sep 25, 2021 at 11:40 am
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login