EXCEL FILTER OF COMMENT CONTENT
You can't filter comment
--
Regards,
Peo Sjoblom
"smartgal" wrote in message
...
On the filter, you can choose the "custom" option and choose "contains."
From there, just enter the criteria you're seeking.
Keep in mind that if you're looking for something like "NA" it will find
*all* instances where "NA" appears so if the word "finance" appears, it
will
show up in your result so you need to be as specific as you can. There
are a
lot of options in "custom" so after some experimentation, you'll probably
come to something useful.
Good luck!
"Dave Peterson" wrote:
Maybe just using Edit|Find and searching through comments would be
sufficient???
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
--
Dave Peterson
|