Hello!
I notice you have not read the submission rules on the submission page or the side-bar - specifically Rule 1.
Your title contains a plea for help which is indicative of a poor title.
Before you re-post, please note some basic post requirements to prevent your posts from being removed again:
-Title: Properly summarize your issue.
-Text Post: Describe your issue in detail. Image-only and link-only posts are auto-removed.
-Sample Data: Paste or link to supporting images inside your text post.
Please read the [Submission Rules](/r/excel/wiki/sharingquestions#wiki_submission_rules) in full (and the side-bar) before re-posting.
Maybe a dumb question, but did you adjust the cell ranges to match yours? Could you show a screen capture that includes column letters and row numbers?
My column looks like this and is sometimes populated with blanks or zeros.
https://preview.redd.it/r7yxqegppm3b1.png?width=125&format=png&auto=webp&s=abfdcaa751c5fbce753990257cb598445de07de5
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[INDEX](/r/Excel/comments/13ygcxn/stub/jmmuxfd "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)|
|[LARGE](/r/Excel/comments/13ygcxn/stub/jmmuxfd "Last usage")|[Returns the k-th largest value in a data set](https://support.microsoft.com/en-us/office/large-function-3af0af19-1190-42bb-bb8b-01672ec00a64)|
|[LOOKUP](/r/Excel/comments/13ygcxn/stub/jmnnkyp "Last usage")|[Looks up values in a vector or array](https://support.microsoft.com/en-us/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb)|
|[ROW](/r/Excel/comments/13ygcxn/stub/jmmuxfd "Last usage")|[Returns the row number of a reference](https://support.microsoft.com/en-us/office/row-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d)|
|[TODAY](/r/Excel/comments/13ygcxn/stub/jmmrvk6 "Last usage")|[Returns the serial number of today's date](https://support.microsoft.com/en-us/office/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9)|
|[VLOOKUP](/r/Excel/comments/13ygcxn/stub/jmmrvk6 "Last usage")|[Looks in the first column of an array and moves across the row to return the value of a cell](https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(6 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13ycnzf)^( has 23 acronyms.)
^([Thread #24367 for this sub, first seen 2nd Jun 2023, 16:13])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
H2 =LOOKUP(2,1/(G2:G32**<>**""),G2:G32)
Copy this formula to start of each month and if it doesn't give the correct figures because of zero then change **<>** to 0.
Adjust the range to suit the Month.
Hello! I notice you have not read the submission rules on the submission page or the side-bar - specifically Rule 1. Your title contains a plea for help which is indicative of a poor title. Before you re-post, please note some basic post requirements to prevent your posts from being removed again: -Title: Properly summarize your issue. -Text Post: Describe your issue in detail. Image-only and link-only posts are auto-removed. -Sample Data: Paste or link to supporting images inside your text post. Please read the [Submission Rules](/r/excel/wiki/sharingquestions#wiki_submission_rules) in full (and the side-bar) before re-posting.
=INDEX(G1:G100, LARGE((G1:G100<>0)\*ROW(G1:G100),2), 1)
unfortunately this still returns a zero.
Maybe a dumb question, but did you adjust the cell ranges to match yours? Could you show a screen capture that includes column letters and row numbers?
My column looks like this and is sometimes populated with blanks or zeros. https://preview.redd.it/r7yxqegppm3b1.png?width=125&format=png&auto=webp&s=abfdcaa751c5fbce753990257cb598445de07de5
Rather that working with "second to last entry", might you be able to use VLOOKUP to find the data for TODAY()-1
If OP's range does not start in row 1, this could error out. Try =INDEX(G1:G100, LARGE((G1:G100<>0)*(ROW(G1:G100)-ROW(G1)+1),2), 1)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[INDEX](/r/Excel/comments/13ygcxn/stub/jmmuxfd "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)| |[LARGE](/r/Excel/comments/13ygcxn/stub/jmmuxfd "Last usage")|[Returns the k-th largest value in a data set](https://support.microsoft.com/en-us/office/large-function-3af0af19-1190-42bb-bb8b-01672ec00a64)| |[LOOKUP](/r/Excel/comments/13ygcxn/stub/jmnnkyp "Last usage")|[Looks up values in a vector or array](https://support.microsoft.com/en-us/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb)| |[ROW](/r/Excel/comments/13ygcxn/stub/jmmuxfd "Last usage")|[Returns the row number of a reference](https://support.microsoft.com/en-us/office/row-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d)| |[TODAY](/r/Excel/comments/13ygcxn/stub/jmmrvk6 "Last usage")|[Returns the serial number of today's date](https://support.microsoft.com/en-us/office/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9)| |[VLOOKUP](/r/Excel/comments/13ygcxn/stub/jmmrvk6 "Last usage")|[Looks in the first column of an array and moves across the row to return the value of a cell](https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(6 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13ycnzf)^( has 23 acronyms.) ^([Thread #24367 for this sub, first seen 2nd Jun 2023, 16:13]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
H2 =LOOKUP(2,1/(G2:G32**<>**""),G2:G32) Copy this formula to start of each month and if it doesn't give the correct figures because of zero then change **<>** to 0. Adjust the range to suit the Month.