Thread: Custom filter
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
BNT1 via OfficeKB.com BNT1 via OfficeKB.com is offline
external usenet poster
 
Posts: 125
Default Custom filter

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