Arshmaan
New member
- Joined
- Oct 20, 2011
- Messages
- 10
- Reaction score
- 0
- Points
- 0
- Location
- Pakistan
- Excel Version(s)
- 2007, 2016
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)..
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?
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?