View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] alfred.cloutier@gmail.com is offline
external usenet poster
 
Posts: 13
Default formula to display first and last items of a list

I have a number of lists in a single column, each list is separated by
a blank row.

Is there a formula that will display only the first and last item of
each list separately? In other words, each list needs to have its own
first and last entry.

Thanks!