« « Changes in the numbers of students majoring in programming and social sciences

Keep it subtle, stupid: Differentiating data values in visualizations » »

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 import databases just for filtering.

« « Changes in the numbers of students majoring in programming and social sciences

Keep it subtle, stupid: Differentiating data values in visualizations » »
  • Nem_cen

    Sooooo helpful!, thank you….

    [Reply]

  • Nem_cen

    thought the same…. I was using sql so I could group by my info XD… I’m ashamed of myself XD….

    [Reply]