Duplicates within expanded rows specific to each acct #

%3CLINGO-SUB%20id%3D%22lingo-sub-3543758%22%20slang%3D%22en-US%22%3EDuplicates%20within%20expanded%20rows%20specific%20to%20each%20acct%20%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3543758%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20a%20pivot%20table%20of%20acct%20%23s%20with%20data%20listed%20for%20each%20acct%20%23.%3C%2FP%3E%3CP%3EI%20need%20to%20find%20duplicates%2C%20not%20across%20the%20entire%20pivot%2C%20but%20just%20duplicates%20(if%20any)%20within%20each%20acct%20%23%20listed.%3C%2FP%3E%3CP%3ETo%20see%20the%20data%20for%20each%20acct%20%23%2C%20you%20have%20to%20expand%20the%20(%2B)%20the%20line%20item%20within%20the%20pivot.%26nbsp%3B%20How%20do%20I%20find%20the%20duplicates%2C%20specific%20to%20each%20acct%20%23%20for%20a%20pivot%20of%20roughly%20150k%20acct%20%23s%3F%20(not%20duplicates%20across%20the%20entire%20pivot).%26nbsp%3B%20Thank%20you%20so%20much%20in%20advance%20for%20any%20feedback!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3543758%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, I have a pivot table of acct #s with data listed for each acct #.

I need to find duplicates, not across the entire pivot, but just duplicates (if any) within each acct # listed.

To see the data for each acct #, you have to expand the (+) the line item within the pivot.  How do I find the duplicates, specific to each acct # for a pivot of roughly 150k acct #s? (not duplicates across the entire pivot).  Thank you so much in advance for any feedback!!

0 Replies