Filtering/Sorting Data

Hello Everyone,

I would like to start by saying that I am not sure if this is possible to do in Excel, our would require Sequel/VBA to achieve what I need. But I am open to either or.

I have a table of 2500+ records that need to be sorted from time to time, and I am attempting to automate this process. (attached sample workbook)

Sample Workbook.xlsx

The table records: Report Date, Staff Name, Status, IN Date, Out Date, Staff ID.

The problem I am having is that sometimes duplicates appear, but without the full information. For example: Pedro Horton is recorded as “IN” on “1/5/2014” but an out is not recorded in this row, then we get a duplicate entry of Pedro Horton but as “OUT” which records both, an IN & OUT date.

What I then need to do is go through the table, look for duplicate entries based on the “IN Date” and remove the duplicates. Now I know you would say “Delete all those without an “Out Date”, but the problem is that some entries will not be a duplicate, but will also not have an “Out Date”.

Any ideas?

This is amazing! I have no problem hiding the extra columns. THANK YOU!!! I am going to study this formula and try to learn how to implement this in the future! Thanks again!

Thank you for mentioning the curly brackets, I was trying to figure out what those were. Reputation added and will mark this solved. Thanks again!