List of N last cells
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
|