62705300019623531 0000009200AR000000027283 HILL , CLAY
62705300019623531 0000009200AR000000046485 HILL , CLAY
62705300019623531 0000009200AR000000027787 HILL, DORIS M
like on the file i post i have a huge file with different duplicate names, for example i want to delete the second line item for Hill Clay even the other numbers are not duplicate , i need only the first record (line Item) and remove the are lines that contain the same first and last name. In Excel i can highlights the column and remove duplicate,it is not working for me, even when I use mark all or RegRex place? maybe I am using wrong path or formula ? please advise!