Thread: Custom filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Amy Brooks Amy Brooks is offline
external usenet poster
 
Posts: 11
Default Custom filter

Try using Data- Filter- AutoFilter, then when you click to set the filter,
choose Custom, and choose 'contains' and type 307

"BNT1 via OfficeKB.com" wrote:

Hi

In a column i have the following example

307
307,607
105,122,151,307,451
405
626

etc

How can I filter to show all those woth 307. In this case, the top 3 records

Thanks in advance
Regards

Brian

--
Message posted via http://www.officekb.com