Time Savers III: Remove duplicate values in Excel

Here's another article that saves Excel customers time, according to verbatim feedback:

• Locate duplicates by using conditional formatting (Excel 2003)

The Excel 2007 version covers the conditional formatting approach and more: 

• Filter for unique values or remove duplicate values (Excel 2007)

And in case you missed them, the first two Time Saver posts were:

• Most popular time savers, starting with two from Excel (about duplicate rows and transposing rows and columns)
• Top time savers II: create a distribution list in Outlook

We'll steadily add more as comments come in. But meanwhile you can search Excel help at the Help and How-to center at Office Online.

-- Holly Thomas