Friday, November 18, 2005

Excel 12 - Cool feature I've wanted forever...remove duplicates

I've been frantically reading the blog I posted for all of your to read yesterday (, and while I first mentioned my excitement for really digging into the web services being rolled out, here's a wonderful feature that I've been begging them for forever: automated duplicate removal.

That's right. I've spent countless small chunks of my life adding temporary columns to data tables and entering formulas like...


Then sorting the entire data table by that new column, and deleting all rows containing "REMOVE" in them.

No more. Check it out at

Getting excited for 12 yet?

No comments: