Thread: Formula to display last entry in a column populated with #N/As
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Formula to display last entry in a column populated with #N/As
You are welcome! Thanks for the feedback!
Stefi

€˛T. Duprex€¯ ezt Ć*rta:

?B?U3RlZmk=?= wrote in
:

=LOOKUP(10^10,B:B)

Thank you Stefi;

Simple, elegant and does the trick.

Reply With QuoteReply With Quote