View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Art Art is offline
external usenet poster
 
Posts: 587
Default Find and Return the Non-Blank entry

_________A
1_________
2_________
3_______Hello
4_________
5_______Hello

I have a single column range (A1:A4). One and only one of the cells contains
a text entry (cell A3 in this example). I want to enter a formula into A5
that will return this text entry.

Thanks,
Art