- Feb 5, 2006
- Office Version
Good day. I'm running Excel 2007 on Windwos Vista Business 32 bit. I host a radio show and track my song requests using excel. I track the name and date of each request along with other information. Every year I compile a list of my callers to recognize them on the air. My workbook is now reaching a count of 2000 rows. I have been very diligent when entering names so that there aren't many differences on repeat callers. I have been copying the original worksheet to a duplicate worksheet to do sorting and deletion of duplicate names so that the final list shows each indicidual caller only once. This is becoming a task. Is there a way to have the second worksheet delete all but one row where the Name column is identical? Thanks in advance for any help.