-
Excel 2013 Flash Fill
I’ve been playing around with the Excel 2013 preview, and damn. It’s nice. Excel newbs and ninjas alike will find Flash Fill – one feature new to Excel 2013 – intuitive, powerful and super convenient. Flash Fill takes the grunt work out of list-making and data manipulation, relying on clever algorithms to recognize patterns and…
-
Compare Two or More Lists in Excel with Conditional Formatting
I’ve recently posted two easy ways to compare two lists in Excel. One uses ISNA and MATCH and one IF and COUNTIF. I like both of these methods because they allow you to: Learn how to use and modify four powerful Excel functions Quickly apply AutoFilter to view just the missing values Easily manage and compare massive…
-
Compare Two or More Lists in Excel with IF and COUNTIF
As I previously discussed, Excel provides many useful ways to automatically compare two lists of data or information. In our other example we compared two lists of four digit account values; for this example we’ll compare two lists of names. You and a friend are throwing an epic party and have each maintained separate guest…
-
Compare two or more lists in Excel with ISNA and MATCH
People compare lists (or columns) of information all the time, and Excel provides several easy ways to do it. Microsoft sums up several real-life examples quite nicely: For financial record-keeping, you often have to compare two lists to find data that appears on one but not on the other. Which new clients need to be…
-
Troubleshooting Arch Linux Wireless Using RF-kill (and Why I’m a Dumbass)
My laptop pwned me the other day, and in the process taught me all about a neat little utility called RF-kill. Here’s the story. One fateful afternoon I carried my laptop from one room into another via walking (gross, I know) to continue working in a fresh environment. After sitting I noticed the little GNOME…