What is the best way in excel to 1) highlight and 2) eliminate duplicates in long! lists? (Without having to download any add in's, etc)

Hi Priscilla

Thank you for your question.

If you have a list that contains rows with identical data (i.e. duplicate records) you can use the Advanced filter feature to get a copy of the list with the duplicates removed. I know this is not exactly what you asked in your question but it will achieve the same result.

To do this:
1. Select a cell within your list of data.
2. Go to Data - Filter - Advanced filter.
3. In the List Range box select the entire list including the row with the headings for each column.
4. Select the Copy to another location option at the top of the dialogue box.
5. In the Copy to box select a blank cell which will represent the starting point for the list without duplicates (as you will end up with a copy of your existing list but without the duplicate rows)
6. Select the Unique Records Only checkbox
7. Click OK.

I hope this helps.
Amanda