Custom filter

[BNT1 via OfficeKB.com]

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

 

[Amy Brooks]

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

 

[Jarek Kujawa]

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

 

[BNT1 via OfficeKB.com]

Hi

thanks

This did work, although the other post was easier, it did not work for me

Not sure where the "yes button" is?

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

Hi

[quoted text clipped - 17 lines]

 

[David Biddulph]

Ignore these time-wasting references to a "Yes" button. That applies only
to people who post to the newsgroup via Microsoft's web interface, so it has
no relevance to people who access the newsgroup by normal methods.
--
David Biddulph

Hi

thanks

This did work, although the other post was easier, it did not work for me

Not sure where the "yes button" is?

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

Hi

[quoted text clipped - 17 lines]