Hi I have the following problem in Excel:
I want to find text doubles in a column and then automatically copy the information of that row to a another, seperate table. This second table then will only contain the doubles.
This is how my table looks now:
NAME PRODUCT ID John Apples 112 Marc Apples 113 Irene Oranges 114
In this case I would like to copy out the information of Marc and John, because they have the same product. I'm sure there is a relativley easy solution to this problem but i was not able to find one. What would you guys propose? Thanks in advance!
Bookmarks