My problem is I have data in Columns, C, D, E, F and if there are duplicates anywhere within each one of these columns they need to be grouped together. I created an index# column in column G and the formula below works for it however I cant make it any longer and I will have to do more columns. Hopefully the below example helps. Let me know if anyone can help.
C D E... G (Index#) 1 2 3 1 1 222 33 1 11 33 1 111 22 3333 2 1111 2222 333 3 11111 22222 3 1
Formula in G2
=IF(COUNTIF(F$2:F2,F2)>1,VLOOKUP(F2,F$1:G1,2,0),IF(COUNTIF(E$2:E2,E2)>1,VLOOKUP(E2,E$1:G1,3,0),IF(COUNTIF(D$2:D2,D2)>1,VLOOKUP(D2,D$1:G1,4,0),IF(COUNTIF(C$2:C2,C2)>1,VLOOKUP(C2,C$1:G1,5,0),MAX(G$1:G1)+1))))
Bookmarks