Thread: Last cell in row range with a result
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Last cell in row range with a result
if you have a row of data , say row 3, with no included blanks, then the last
value in that row is:

=INDEX($3:$3,COUNTA($3:$3))


--
Gary''s Student - gsnu200713
Reply With QuoteReply With Quote