#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Please add a workbook, it is so much easier than recreating data!!!!!!!
|
#3
|
|||
|
|||
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)) |
#4
|
|||
|
|||
Purfleet, thank you
These array formulas work |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
First of all check to cells and after drop down list | DIMI | Excel Programming | 2 | 11-27-2019 12:15 AM |
How to match one list with another and return certain values from corresponding cells in excel | Oluagbe1 | Excel | 10 | 02-11-2019 07:00 PM |
Formating Partial cells in a large list | Zajac | Excel | 3 | 08-16-2016 09:13 AM |
convert list in one cell into multiple cells | RayK | Excel | 2 | 02-09-2016 04:53 AM |
Drop down list to overlay column of cells with different formulae | TomJ | Excel | 0 | 12-19-2015 08:55 AM |