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.
Recent Comments — Join the Discussion!