View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Extracting entries from long list

It sounds like you want to see the list but only the rows that contain
comments. If this is correct then maybe what you want is to use
AutoFilter.

Select the comments heading then click on Data - Filter - AutoFilter

Click on the down arrow by the comments heading and select the
(NonBlanks) item in the list.