Thread: help with formula for last input in column
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default help with formula for last input in column
array formula to be validated with ctrl + maj + enter

--
isabelle


Le 2012-01-13 09:34, isabelle a écrit :
hi Dmag,

=INDEX(A1:A100,MAX(IF(A1:A100<"",ROW(A1:A100))))
array formula to be validated with


Reply With QuoteReply With Quote