It's very crude. I'm positive there are better ways to do it in excel that would hilight and group dupes but I'd be jewgling how. Also can copy/paste the results of the pivot table and then sort that to hide all the 1's.
It's very crude. I'm positive there are better ways to do it in excel that would hilight and group dupes but I'd be jewgling how. Also can copy/paste the results of the pivot table and then sort that to hide all the 1's.
(post is archived)