View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Filter first two characters

Assuming you're using AutoFilters...

Open filter, choose custom
Criteria1, look for 11*
Choose "or"
Criteria2, look for 15*
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mary" wrote:

Hello,
I need to filter a column of data that has 4 characters on the first two
characters only.

1100
1110
1140
1190
1550
1590
1600
1700

I want to filter everything starting with 11xx and 15xx. The list will vary
by month but I will always need those two groups.

Thanks!
Mary