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
|