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:
docs.google.com/spreadsheets/...
Негізгі бет Second to last non-blank cell excel
Пікірлер: 25