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 (http://blogs.msdn.com/excel/), 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...

=IF(B3=B2,"REMOVE","")

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

No more. Check it out at http://blogs.msdn.com/excel/archive/2005/11/04/489259.aspx.

Getting excited for 12 yet?

No comments: