View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
George[_2_] George[_2_] is offline
external usenet poster
 
Posts: 4
Default Last cell in row range with a result

Gary''s Student wrote:
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))


How are formulas that have no results treated.