Second to last non-blank cell excel

Описание: This video shows how to find second to last non-blank cell excel. The last non-blank cell is easy to find using XLOOKUP but this is a little tricky
3 Methods are adopted

00:00 Introduction
00:55 Method 1 (INDEX+LARGE+SEQUENCE)
05:02 Method 2 (FILTER+INDEX+COUNTA)
10:28 Method 3 - LARGE+IF+SEQUENCE

Sample Workbook:
https://docs.google.com/spreadsheets/...