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

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

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

Hi

thanks

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

Not sure where the "yes button" is?



Jarek Kujawa wrote:
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]
--
Message posted viahttp://www.officekb.com

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

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

"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:96cdc25577222@uwe...
Hi

thanks

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

Not sure where the "yes button" is?



Jarek Kujawa wrote:
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]
--
Message posted viahttp://www.officekb.com

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