It depends on what you’re trying to do with the list, actually… Excel knows how to filter your rows so that it hides rows containing duplicate information:
1) Highlight the entire column
2) Go to Data. Press Filter / Adanced Filter
3) If an alert pops up, press “Okay”
4) Check “Unique Records Only” and press “Okay”
**Your duplicate rows should now be hidden**
To Delete Duplicate rows, rather than hiring, continue as follows:
5) Copy the shortened list and paste it over itself (don’t ask why; just trust me on this one)
6) Then make what you’ve just pasted BOLD or Highlighted or something to differentiate it. Whatever takes your fancy
7) Highlight the whole column again
8) Go to Data. Press Filter / Show All
9) Any data that is now not bold (or whatever you used to differentiate) is a duplicate. Delete it.