Hi Forum,
I have a column of part numbers and the ones that I am interested in have an asterisk/asteriks (i hate that word!) suffix. E.g. 9754-ME-099*
I can use Find to locate them by using wildcards such as *~*~.
I would like to be able to filter for these numbers but when I use autofilter and Contains *~*~ it doesn't find anything. It just returns an empty column.
How would I filter for numbers ending in * ?
Thanks very much
Dave
I think the only way you can do this is to use a helper column with the FIND function, which doesn't accept wildcard characters, in it and then Autofilter on that.
Something like this:
=IF(ISNUMBER(FIND("*",A2)),"Asterisk","")
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Use Advanced Filter with "*~*" in criteria, see attachment (or Autofilter with "Contains >> *~* )
Last edited by WHER; 03-16-2012 at 07:37 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks