Delete Rows using multiple criteria

I've scoured the forums and couldn't find exactly what I'm looking for...

I would like to delete rows that have identical entries in 3 columns, and keep the row based on a criteria in the 4th column. Here's a simplified table/example of what I mean:

Name Building Suite Expiry Date
ABC Building 1 200 11/30/2011
ABC Building 1 200 11/30/2015
ABC Building 1 800 11/30/2011
XYZ Building 2 200 5/31/2011
XYZ Building 2 200 4/30/2013
XYZ Building 2 200 3/31/2018


So I would like to delete rows with a duplicate name, building and suite, BUT keep the row with the latest expiry date.

In the end, there should only be 3 entries:

Name Building Suite Expiry Date
ABC Building 1 200 11/30/2015
ABC Building 1 800 11/30/2011
XYZ Building 2 200 3/31/2018


Thank you in advance for the help. Keep up the good work here.

-M

Thanks for the reply. That option on Excel 2010 sounds very convenient, but unfortunately I'm stuck on the 2003 version.

I've tried different ways to sort, but I think the only way is through VBA code...