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