Hi.
I have huge sorting job in Excel.
I have a excel file from each year.
And I put these together to a huge excel file.
And I need to track down the last activity if the customer is listed multiple times.
I could just go through and delete the rows, but the last row.
But, that takes a lot of time.
I was hoping someone has been through this and can give a tip on a solution.
Format:
Last activity (year only) - Customer number - Customer name
2010 - 1001 - Company A
2011 - 1001 - Company A
2012 - 1001 - Company A
2013 - 1001 - Company A
2010 - 1002 - Company B
2011 - 1002 - Company B
2012 - 1002 - Company B
2010 - 1003 - Company C
2012 - 1003 - Company C
2011 - 1004 - Company D
2012 - 1005 - Company E
The rows I need will be:
2013 - 1001 - Company A
2012 - 1002 - Company B
2012 - 1003 - Company C
2011 - 1004 - Company D
2012 - 1005 - Company E
So can I do this in Excel?
Thanks in advance...
Bookmarks