Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Looking for a formula that will look down a column of cells that has
many blanks gapped in-between other cells containing text, numbers,
etc and for each block of cells with continuous data, find the last
non-blank cell and return a value that is 2 columns away in the same
row as the last non-blank cell. To clarify, there may be data that
extends down thousands of cells and the blocks of non-blank data in
the applicable column may be as few as 1 continuous or as many as 100
continuous pieces of data and I am only wanting to pull the source
cell that is adjacent to the last data populated cell in each block,
but for all blocks down the spreadsheet.
 
hi,

array formula to validate with "ctrl + shift + enter"

=INDEX(C:C,MAX(IF(A3:C100<>"",ROW(A3:C100))),1)

--
isabelle



Le 2011-08-18 11:38, Jim a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

row number of last non-blank cell 14
How to reference last non-blank cell value from a column cells? 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
How to return the last non-blank cell in a column that is TEXT 7
Next-To-Last, Non-Blank, Rightmost Value in a Row 6
Last value in column before blank 10
Reference to next non-blank cell 5
Total a column contingent upon the cell to the right being non-bla 3

Back
Top