View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default How to return the last non-blank cell in a column that is TEXT

On Mon, 6 Oct 2008 15:14:11 -0700, VSlaybaugh
wrote:

In any cell of column C of Sheet 2, I want it to return the last non-blank
cell from Sheet 1 Column D...being the last non-blank cell in or ABOVE that
row. Column D in sheet 1 has TEXT and no numbers. My range I'm working from
on sheet 1 is D7:D7000.



=LOOKUP(2,1/(LEN(D7:D7000)0),D7:D7000)

--ron