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
    East Sussex
    Posts
    22,225

    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?

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