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?
Friday, November 18, 2005
Excel 12 - Cool feature I've wanted forever...remove duplicates
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment