I'm working with Excel 2007. I have 700+ lines of information on an Excel sheet and I am using filter to filter out when the certain employees started working for a certain branch and/or team using the "date" column.
For example, let's say John started working at a branch in New York starting on 2009-1-01 as a consultant but in 2010-1-01, he moved to a different team, say, accountant.
Now when I filter out the dates for 2009-1-01 and up to see how many people were working at New York branch, John, the same person, would appear twice because he moved to a different team but he's still at same branch.
Is there a way I can remove this duplicity and have John only show up once, either as a consultant or accountant (preferably as an accountant because it's the most recent) without permanently deleting the whole row?