Michelle Minkoff

Random time-saving Excel tip.  Want to condense a long column to only display unique entries?  Go to the Data menu, select Filter and Advanced Filter.  Voila, a check box labeled “Unique records only”.  Don’t know why I never noticed this before.

Or, you know, you could use Group By in SQL.  But no need to import databases just for filtering.

Related posts you might enjoy:

• April 11, 2010 -- Data Delver: Paul Monies, The Oklahoman
• March 25, 2010 -- Self-teaching data and programming skills
• March 8, 2010 -- Data Delver: Jennifer LaFleur, ProPublica
• February 28, 2010 -- Django app #2: Conquering forms and Google Maps API
• February 21, 2010 -- Is a flat text file or a database right for an app?
• February 2, 2010 -- Recognize the importance of journalistic creativity

Tags: databases, excel, group by, random time, sql, unique records

This entry was posted on Wednesday, January 20th, 2010 at 6:17 pm and is filed under CAR, excel, sql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.