How to “Group By” in Excel

Posted by on Jan 20, 2010 in Blog, CAR, excel, sql | 2 Comments

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 […]