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
|