How to return a list of the last three cells of nuninterrupted sequence consecutive cells in the column. I also need a variant, how to return a value from the last 6 cells of an uninterrupted sequence consecutive cells.
So I want to have a choice of returned cells (i.e. condition). The condition is located in the D2 cell. Please formula for Excel 2013.

Example in the A column

Data
10
25
Total 15
30
38
Total 8
29
47
Total 18
16
32
Total 16
19
75


Total 56
48
99
Total 51
Empty/Blank cell
Empty/Blank cell
Total 0
Empty/Blank cell
Empty/Blank cell
Total 0
etc...





Expected results


Three of the last filled cells in continuous sequence
48
99
Total 51

Six of the last filled cells in continuous sequence
19
75
Total 56
48
99
Total 51

Please add a workbook, it is so much easier than recreating data!!!!!!!

Not the best, but a start

for 3 - =INDEX(A:A,MATCH(TRUE,A:A="",0)-ROWS(C1:$C$3))
for 6 - =INDEX(A:A,MATCH(TRUE,A:A="",0)-ROWS($C1:C$6))

Attached Files

List of N last cells_ar12.xlsx (9.9 KB, 9 views)

Purfleet, thank you
These array formulas work