Finding Dupes in column array in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3194339%22%20slang%3D%22en-US%22%3EFinding%20Dupes%20in%20column%20array%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3194339%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20been%20tasked%20with%20takin%20the%20data%26nbsp%3B%20provided%20(just%20a%20small%20sample)%20to%20identify%20if%20the%20plans%20have%20all%20the%20same%20elements%20configured%20the%20same.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Attached%20the%20example%20and%20basically%20need%20to%20Identify%20Each%20of%20the%20Plan%20Marketing%20Names%20that%20have%20the%20same%20plan%20configuration%20(Rows%209%20through%20152)%20into%20a%20new%20worksheet%20that%20shows%20the%20duplicated%20plans%20together%20and%20the%20unique%20one%20separately.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPROBLEM%201%20-%20need%20the%20Check%20columns%20I%20started%20for%20the%20first%203%20to%20be%20a%20function%20for%20the%20entire%20data%20set%20in%20each%20tab%20which%20is%2077%20Columns%20long.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3EPROBLEM%202%20-%20need%20to%20do%20this%20function%20across%20several%20tabs%3C%2FP%3E%3CP%3EPROBLEM%203%20-%20need%20to%20do%20this%20function%20across%20several%20different%20documents%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3194339%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello, I have been tasked with takin the data  provided (just a small sample) to identify if the plans have all the same elements configured the same.  

 

I have Attached the example and basically need to Identify Each of the Plan Marketing Names that have the same plan configuration (Rows 9 through 152) into a new worksheet that shows the duplicated plans together and the unique one separately.

 

 

PROBLEM 1 - need the Check columns I started for the first 3 to be a function for the entire data set in each tab which is 77 Columns long.    
PROBLEM 2 - need to do this function across several tabs

PROBLEM 3 - need to do this function across several different documents 

0 Replies