Hi:
I have a table the contains Notes. The notes expand multiple rows which are not the same in every case. See example below... I can't select on a specific Row #. I can't select on specific words because you have no words in common on which to select for each ID.
The only thing I have to go on is that on the report I'm creating
there is a line --------------------------------------------------------
There a bunch of NOTES
NOTES
NOTE
At the end of the notes there is the word CULTURE
QUESTION: How do I remove the Notes between the lines and the word CULTURE without just saying does not CONTAIN ([NOTE], "anything").
id row Note
A 1 Yes dkfdaldfj
A 2 ---------------------------------------------------
A 3 CULTURE
A 4 no dadalit
A 5 anything
B 1 could say anything
B 2 xxxxxx
B 3 ---------------------------------------------------
B 4 CULTURE
Thanks, Lenore Scanlon
Solved! Go to Solution.
Thanks very much. This really helped