I have a table in Excel that includes the following 4 columns: Employee number, name, date and Job Title. I download all employee information into the table after each pay. I would like to have a column in the table that would allow me to identify the most current job title information (i.e. a unique list of the most current job title by Emp #). Is there a formula that I could incorporate into the table that would place a 1 next to the latest information that would allow me to use an Auto Filter and obtain a unique list of all the employee's most recent titles? I hope I've explained this clearly. Thank you for your assistance.