I need to be able to sort or filter criteria in a cell, cells have multiple entries.
colum F holds the criteria to be filtered or sorted.
.....need all rows with instances of group 'A' to be filtered or sorted.
I need to be able to sort or filter criteria in a cell, cells have multiple entries.
colum F holds the criteria to be filtered or sorted.
.....need all rows with instances of group 'A' to be filtered or sorted.
Last edited by VBA Noob; 10-03-2007 at 06:08 AM.
Data > Filter > Custom > contains > A
http://www.contextures.com/xlautofilter01.html#Custom
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks