View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default EXCEL FILTER OF COMMENT CONTENT

That's probably because you can't filter by words within comments with any
built-in Excel functions?

You'd need a custom macro to go through the cells in question and examine
them to see if they have a comment and then 'filter' based on the results of
the examination of the comment text after determining that a cell even had a
comment associated with it.

"Bart" wrote:

I want to filter on a key word for a group of cells and the contents of the
comments. Cannot find any information on filtering on the key word within the
comment.
Thanks
Bart