Results 1 to 2 of 2

Creating pivot table with filtered data

This is a discussion on Creating pivot table with filtered data within the Excel Questions forums, part of the Question Forums category; Hi-- I am trying to create a pivot table with data filtered by 'unique entry', but when I highlight the ...

  1. #1
    Board Regular
    Join Date
    Jun 2008
    Posts
    95

    Default Creating pivot table with filtered data

    Hi--

    I am trying to create a pivot table with data filtered by 'unique entry', but when I highlight the data and create the pivot table, it uses all of the rows, even those that are repeated (i.e. not unique).

    How can I make a pivot table and only use the unique entries? Any help would be much appreciated. Thanks!

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    ex machina
    Posts
    21,352

    Default Re: Creating pivot table with filtered data

    You could use an advanced filter on the original data to copy the unique rows somewhere else and then base the pivot off that?
    Rory
    Microsoft MVP - Excel
    Posting guidelines | Forum rules | FAQs | HTML Maker

    Please use CODE tags when posting code. Either select the code and then press the # button or type them manually:
    [CODE] Your code goes here [/CODE]

    Excel matters

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com