use a helper column with this formula:

=IF(ISERROR(FIND("307",A1)),"","incl. 307")

then apply an autofilter on "incl. 307"

pls click YES if it helped




On 29 Maj, 12:36, "BNT1 via OfficeKB.com" <u19326@uwe 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 viahttp://www.officekb.com