Excel's Filter feature also can do this. What it would do is copy the
unique records to a different location. Select Data, Filter, Advanced
Filter from the Excel menu. You want to:
Make sure Excel selects the right list.
Tell Excel where to put the filtered data
Make sure Unique Records only is cheked.
Make sure your columns have a heading and the heading should be bold or
otherwise distinguishable from the rest of your list.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
