+ Reply to Thread
Results 1 to 3 of 3

Hide duplicate rows from filtered data

  1. 10-20-2011, 04:30 AM #1
    Arshmaan
    Arshmaan is offline
    Registered User
    Join Date
    05-25-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    11

    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)..

    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
    Last edited by Arshmaan; 10-20-2011 at 04:32 AM.
    Reply With QuoteRegister To Reply
  2. 10-20-2011, 05:03 AM #2
    MUSTAFAINE
    MUSTAFAINE is offline
    Registered User
    Join Date
    12-24-2009
    Location
    Istanbul
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Hide duplicate rows from filtered data

    I think you need to use pivot table.. Try to add one from INSERT / Pivot Table
    Reply With QuoteRegister To Reply
  3. 10-28-2011, 06:37 AM #3
    Arshmaan
    Arshmaan is offline
    Registered User
    Join Date
    05-25-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Hide duplicate rows from filtered data

    thnx Mustafaine i've done this with advance filter and sumproduct formula

    very thnx to Peter who solved my problem
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1