Thread: Next to last non-empty cell in row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cong Nguyen Cong Nguyen is offline
external usenet poster
  
Posts: 20
Default Next to last non-empty cell in row
Domenic,
Thank you
--
Cong Nguyen



"Domenic" wrote:

Does the data contain formula blanks ("") ? If so, try the following
formula instead...

=INDEX(A2:A100,LARGE(IF(A2:A100<"",ROW(A2:A100)-ROW(A2)+1),2))

Note that the formula needs to be confirmed with CONTROL+SHIFT+ENTER,
not just ENTER.

Hope this helps!

In article ,
Cong Nguyen wrote:

Domenic,
The formula for text gives the last non-empty data, not the previous.
Thank you
--
Cong Nguyen


Reply With QuoteReply With Quote