var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Advance Filter - "does not end with"
I would like to use advance filter on a column with 4 character text entries. I want to see all entries that do not end with "RD". I can do this with the regular filter on, but I want to extract a list using the advance filter.
Make sure the column has a meaningful header in the first row. I have no idea what your data represesnts so let's say the header is Characters.
The criterion in the criteria range you would use is:
The * is a wildcard which represents any number of characters.
Hope that helps...
Last edited by Colin Legg; 12-30-09 at
advance filter -"dows not end with"
This worked perfectly. Thank you.
you are going wrong you using only "RD" but actual code is " <>*RD "
And you have to also make sure to use * .