Excel's AutoFilter feature is easy to implement and use, but it can do more than first meets the eye. The trick is to be a bit creative. The tips in this article aren't related in any way; they all ...

Generate a list of unique entries in an Excel column Your email has been sent When you need to get rid of duplicates in a column, Excel's advanced filtering options will do the trick. This quick ...

Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...