04 Jan '13, 5pm

Advanced Filters: Excel's Amazing Alternative To Regex

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

This is just an amazing piece by @aceofspadeshq...

ace.mu.nu 09 Jan '13, 4pm

Michael Totten has written a crackerjack piece -- or at least I think it is -- about this principle in action among our fo...

#webmarketing Post : Excel Statistics for SEO a...

seomoz.org 05 Jan '13, 1am

Everybody has probably already realized that there is almost no data that we cannot get. We can get data about our website...

Excel Statistics for SEO and Data Analysis

seomoz.org 04 Jan '13, 7pm

Everybody has probably already realized that there is almost no data that we cannot get. We can get data about our website...

Calculate standard resistor values in Excel:

Calculate standard resistor values in Excel:

edn.com 03 Jan '13, 3pm

Using standard resistor values can greatly impact the accuracy and predictability of a circuit by eliminating rounding err...

@GianPostino Start out with these and work yourself through. Amazing coffees.

@GianPostino Start out with these and work your...

hasbean.co.uk 14 Jan '13, 5pm

Colombia Huila Pitalito Oporapa £4.20 In the cup expect sweetness by the bucket load: chocolate mixed with walnuts and bro...

Amazing war zone sketches by artist Rob Bates

Amazing war zone sketches by artist Rob Bates

milblogging.com 06 Jan '13, 3pm

“This deployment is coming to an end, in a few days we will be on a plane back to the United States to rejoin our family a...

Amazing document on performance art in Singapore. Wish I came across it a month earlier.

Amazing document on performance art in Singapor...

instagram.com 04 Jan '13, 12pm

Amazing document on performance art in Singapore. Wish I came across it a month earlier.

Excel Statistics for SEO and Data Analysis via ...

seomoz.org 06 Jan '13, 3pm

Everybody has probably already realized that there is almost no data that we cannot get. We can get data about our website...

Importing CSV and Excel #rails #asciicasts

asciicasts.com 02 Jan '13, 1am

In episode 362 we showed how to export database records to a CSV or Excel file. Since then there have been a number of req...

CALLING ALL DATA GEEKS: These three GPS watches will track, well, pretty much everything

CALLING ALL DATA GEEKS: These three GPS watches...

runnersworld.com 09 Jan '13, 2pm

Better known for its heart rate-monitoring software, Polar also makes some solid GPS tracing devices. The RC3 is the compa...