Results 1 to 4 of 4

Thread: Hide duplicate rows from filtered data

Threaded View

  1. #1

    Hide duplicate rows from filtered data

    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?
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •