MrExcel Publishing
Your One Stop for Excel Tips & Solutions

filter


Posted by Kim on January 30, 2002 4:33 AM

i have a column of names, i would like to filter on one specific name. In the column of names, there could be two or three names in a specific cell. How do i filter to get just the one specific name?


Posted by Jim on January 30, 2002 4:37 AM

Autofilter is easiest. Turn autofilter on and select custom from the drop down list. Then contains enter name and you're away!

Good luck.

jim