View Single Post
  #1   Report Post  
Old August 18th 11, 04:38 PM posted to microsoft.public.excel.worksheet.functions
Jim[_14_] Jim[_14_] is offline
external usenet poster
First recorded activity by ExcelBanter: Aug 2011
Posts: 1
Default Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS

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.