Good Evening -- I have a spreadsheet that I need to filter and display rows that in a specifued Column, CONTAIN specified Character Values.
IE I Need to filter and display ( preferably in a seperate sheet ) all rows that contain CD in Column AK . Typical Values in that column would be CD International - Box Set CD & DVD - CD Rock - LP Blues - VHS Music Rock - Book Paperback Science Biology - Cassette Jazz - Audio CD Fiction Humor - etc.
After doing the Advanced Filter Tutorials and then searching for the syntax to define Contains, I have found that filtering by "Contains" feature is N/A.
Would someone be kind enough to share knowledge and give me some ideas of where to look next for the best way to do this. My Excel Skills are some above beginner but, by no means advanced.
Thank You
IE I Need to filter and display ( preferably in a seperate sheet ) all rows that contain CD in Column AK . Typical Values in that column would be CD International - Box Set CD & DVD - CD Rock - LP Blues - VHS Music Rock - Book Paperback Science Biology - Cassette Jazz - Audio CD Fiction Humor - etc.
After doing the Advanced Filter Tutorials and then searching for the syntax to define Contains, I have found that filtering by "Contains" feature is N/A.
Would someone be kind enough to share knowledge and give me some ideas of where to look next for the best way to do this. My Excel Skills are some above beginner but, by no means advanced.
Thank You