Advanced Filters: Excel's Amazing Alternative To Regex

If you accidentally include blank cells at the bottom of your criteria range, you will cancel out your criteria because Excel treats blank cells as wildcards that include everything. If you want to copy your range to a new worksheet, you need to start the process on the new sheet and just reference the original dataset. Excel won’t let you start on the sheet where your dataset is and select a new worksheet for the Copy To range. If you filter your data in place, you can’t have more than one table on a worksheet with advanced filters applied. When you apply filters to the second one, you’ll lose the filters on your original table. As mentioned in the post, Clear is broken in Excel 2011 for Mac — at least for me. Let me know in the comments if it works for you! You’ll have to use Command-Z to clear the filter or select the heading and choose Filter. Ironically, this causes E...

Full article: http://searchengineland.com/advanced-filters-excels-amazi...

Tweets

@OLBizBuilders » 22 Jan '13, 10pm
Advanced Filters: Excel's Amazing Alternative To Regex [link] Regex Fun!
@lookadoo » 16 Jan '13, 5pm
Get your GA groove on! Advanced Filters: Excel’s Amazing Alternative To Regex [link] by @anniecushing
@IweinD » 10 Jan '13, 5pm
Ever cursed Excel for not supporting regex? Here's a way to get around that ... after a fashion. [link]
@lyena » 10 Jan '13, 2am
Advanced Filters: Excel's Amazing Alternative To Regex [link] by @AnnieCushing [another excellent tutorial]
@andrewsaladino » 09 Jan '13, 5pm
Excel to the MAX! | Advanced Filters: Excel's Amazing Alternative To Regex [link] by @AnnieCushing via @sengineland
@Avinio » 09 Jan '13, 10am
RT @SEOcopy: RT @sengineland Advanced Filters:Excel’s Amazing Alternative To Regex @AnnieCushing [link] | The gift that keeps giving
@SEOcopy » 09 Jan '13, 12am
RT @sengineland Advanced Filters:Excel’s Amazing Alternative To Regex @AnnieCushing [link] | The gift that keeps giving
@mjcachon » 08 Jan '13, 6pm
“@MYAnalytics: Advanced Filters: Excel's Amazing Alternative To Regex [link] vía @sengineland #analiticaweb #measure”
@davebuesing » 08 Jan '13, 5pm
Crazy helpful >> Advanced Filters: Excel's Amazing Alternative To Regex [link] via @sengineland @anniecushing #data
@ttwelsh » 08 Jan '13, 3pm
No time now but for sure reading this later. Advanced Filters: Excel's Amazing Alternative To Regex [link] via @sengineland
@Ken_Mok » 08 Jan '13, 12pm
learn a new excel skill [link] [link]
@joristoonders » 08 Jan '13, 10am
RT @yonego: Advanced Filters: Excel’s Amazing Alternative To Regex [link] Via @sengineland
@MYAnalytics » 08 Jan '13, 8am
Advanced Filters: Excel's Amazing Alternative To Regex [link] vía @sengineland #analiticaweb #measure
@Iodine74 » 08 Jan '13, 4am
RT @TheNextCorner: Advanced Filters: Excel's Amazing Alternative To Regex [link] by @anniecushing
@HallamInternet » 07 Jan '13, 8pm
SusanHallam: If you use Analytics, and hate Regex, then read this: [link] ^
@brianprovost » 07 Jan '13, 7pm
Advanced Filters: Excel's Amazing Alternative To Regex [link] Amazing work by @anniecushing
@vincekeay » 07 Jan '13, 5pm
How have I only just discovered this -> Advanced Filters: Excel's Amazing Alternative To Regex [link]
@Zen2Seo » 07 Jan '13, 4pm
@AnnieCushing's rockin' again on @sengineland: [link] Advanced Filters: Excel’s Amazing Alternative To Regex
@keywordeye » 07 Jan '13, 4pm
RT @willcritchlow: Advanced Filters: Excel's Amazing Alternative To Regex [link]
@waworld » 07 Jan '13, 3pm
Excellent Post - Advanced Filters: Excel's Amazing Alternative To Regex [link] from @anniecushing
@GeorgeMichie1 » 07 Jan '13, 3pm
@anniecushing is an excel hondo! Advanced Filters: Excel's Amazing Alternative To Regex [link] via @sengineland
@petrakraft » 07 Jan '13, 10am
RT @hannah_bo_banna: More excel awesome from @anniecushing - Advanced Filters - Excel's Alternative to Regex: [link]
@SEOptimism » 07 Jan '13, 8am
RT @wayneb77: Advanced Filters: Excel's Amazing Alternative To Regex // [link] //
@portentint » 06 Jan '13, 10pm
Advanced Filters: Excel's Amazing Alternative To Regex [link] Awesome tool right there in Excel, from @anniecushing
@sebaspindu » 06 Jan '13, 5pm
RT @seohimanshu: Save it => Advanced Filters: Excel's Amazing Alternative To Regex [link] via @sengineland
@Beatever » 06 Jan '13, 10am
Tiens Excel heeft soort regex. [link] #bijstuderen
@TypeAccord » 06 Jan '13, 12am
This is worth reading! Advanced Filters: Excel's Amazing Alternative To Regex [link] via @sengineland @AnnieCushing
@Beezix » 06 Jan '13, 12am
The alternative to Regular Expressions in #Excel is Advanced Filters. @AnnieCushing explains: [link]
@secretmirth » 05 Jan '13, 9pm
RT@neyne: Make yourself a cup of coffee and sit down with this awesome @AnnieCushing post on advanced filters in Excel [link]
@sMichaelGriffin » 05 Jan '13, 8pm
RT @wheresitworking: Advanced Filters: Excel's Amazing Alternative To Regex [link] - Great post by @anniecushing!
@nzaiter » 05 Jan '13, 6pm
TOP! RT @edgar_sanchez: RT @MiguelLopezGo: RT @richardbaxter: Advanced Filters: Excel's Amazing Alternative To Regex [link]
@TiggeritoTimes » 05 Jan '13, 6pm
Advanced Filters: Excel's Amazing Alternative To Regex via @Hobo_Web: One thing I’ve never understood about Excel is... [link]
@marymendola » 05 Jan '13, 4pm
RT @neyne: Make yourself a cup of coffee and sit down with this awesome @AnnieCushing post on advanced filters in Excel [link]
@neyne » 05 Jan '13, 3pm
Make yourself a cup of coffee and sit down with this awesome @AnnieCushing post on advanced filters in Excel [link]
@tauseefazhar » 05 Jan '13, 3pm
Advanced Filters: Excel's Amazing Alternative To Regex [link] #excel #seotool
@ChristianBk » 05 Jan '13, 7am
Advanced Filters: Excel's Amazing Alternative To Regex [link] via @sengineland (Excel for Mac focus? Very good!)
@CedarBrown » 05 Jan '13, 4am
Advanced Filters: Excel's Amazing Alternative To Regex [link] | @AnnieCushing (Great tips here!!)
@jm_cook » 05 Jan '13, 4am
RT @DonnaFontenot: Advanced Filters: Excel's Amazing Alternative To Regex [link] (Oh, Annie, you are the goddess of this stuff! I bow to you.)
@DonnaFontenot » 05 Jan '13, 4am
Advanced Filters: Excel's Amazing Alternative To Regex [link] (Oh, Annie, you are the goddess of this stuff! I bow to you.)
@RudiBaum » 05 Jan '13, 3am
Excel for SEO on Mac done right: [link] by @AnnieCushing
@sharethis_tech » 05 Jan '13, 3am
Advanced Filters: Excel's Amazing Alternative To Regex [link] via @sharethis
@danthies » 05 Jan '13, 1am
RT @gfiorelli1: Advanced Filters: Excel's Amazing Alternative To Regex [link] on @sengineland < The magic of @anniecushing continues in 2013.
@shuey03 » 04 Jan '13, 11pm
RT @blueglass: Advanced Filters: Excel's Amazing Alternative To Regex [link] by @AnnieCushing on @sengineland
@AnnieCushing » 04 Jan '13, 11pm
.@thehipmunk Your ranking data was featured in this @searchengineland post. Because you guys are so cool. [link]
@mrkylemitchell » 04 Jan '13, 10pm
Second post today that makes hating excel difficult: easy + ragex in one sentence will always be attractive. [link]
@andrewbjensen » 04 Jan '13, 10pm
I love Excel, but I confess I haven't really gotten into advanced filters. This article makes me want to learn more: [link]
@chadgardner » 04 Jan '13, 8pm
Advanced Filters: Excel's Amazing Alternative To Regex [link] Holy Nerd, I love this!
@armin_volkmann » 04 Jan '13, 8pm
RT @WeejeeLearning: Advanced Filters: Excel’s Amazing Alternative To Regex [link]
@seotweetz » 04 Jan '13, 8pm
RT @THERCOM1: Advanced Filters: Excel's Amazing Alternative To Regex [link] via @sengineland #SEO
@CyrusShepard » 04 Jan '13, 8pm
If you're terrible at regex check out Excel's Amazing Alternative [link] via @sengineland