I have the following data to start with:

```
Sr. No Conf. By Prod
1 A X
2 B Y
3 A Z
4 B X
5 A X
6 B Y
7 A Y
8 B M
9 A N
10 B O
```

I am interested in column `Prod`

. I want only those values which have been repeated more than once in column `Prod`

.

This is the output I expect after the data has been filtered:

```
Sr. No Conf. By Prod
1 A X
2 B Y
4 B X
5 A X
6 B Y
7 A Y
```

Here is what I have done for now. Simply highlighting the duplicate values isn't of much use to me. So I created a pivot table as follows:

This gives me a count of how many times each element in `Prod`

has been repeated. If I double click on each of the numbers in the `Count of Prod`

column it gives me the details of those entries from the original table.

However, I want this for all the items where the count is more than 1.

Any other ideas on how I can get the desired output?