Hide duplicate rows from filtered data

[Arshmaan]

I have a problem and i have to explain you with my exact data...

my excel sheet is something like that:

Column A (Name), Column B (MSISDN), Column C (Date) Column D (time) and Column E (Location)..

Name	MSISDN	Date	Time	Location
STO Poultry (Sheikhupura) Dr. Muzaffar Ali	+923362550536	01/9/2011	12:37 PM	Ravi Ryan Mouza Goband Tehsil Farozewala & District Muredke Sheikhupura Ravi Rayan
STO Poultry (Sheikhupura) Dr. Muzaffar Ali	+923362550536	02/9/2011	1:37 PM	New Banbosan road, Lari Adda, Nawa Lahore, Lahore Cantt.
STO Poultry (Sheikhupura) Dr. Muzaffar Ali	+923362550536	03/9/2011	1:37 PM	Ravi Ryan Mouza Goband Tehsil Farozewala & District Muredke Sheikhupura Ravi Rayan
STO Poultry (Sheikhupura) Dr. Muzaffar Ali	+923362550536	04/9/2011	2:37 PM	Ravi Ryan Mouza Goband Tehsil Farozewala & District Muredke Sheikhupura Ravi Rayan
STO Poultry (Sheikhupura) Dr. Muzaffar Ali	+923362550536	05/9/2011	2:37 PM	Muridkey Road, Ferozwala, rasheed Garh, Lahore
SPO Farm (Lahore) Zubair Ali	+923362550537	01/9/2011	12:37 PM	Jam Saqid Road, Near new thana Garden Town Lahore

Now First i filter by SPO Name (Column A) then Date (Column C) and then Hide duplicate locations (duplicate Rows in Column E)..

can anybody help me out?