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!
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!