Need to omit records w/same data in a field

[Elon]

Using a database w/16,000 records of jobs we've done. Want to sort it to make a client list, not a job list. Therefore, don't want records with the same CLIENT NAME to be found unless the data in the ATTENTION field is different. (Only want to find most current record for, say, ABC Co., and only want to find multiple records for ABC Co. if the person's name in the ATTENTION field is different from others already found.)

Would appreciate any help. Thank you.