Script to find duplicate groups of data in no specific order

[Craig Willett]

Hi, I'm looking for a function that will find duplicate groups of data.  Say I've got something like:

What I'm looking for is a function that will go through and match the two groups that are the same (the 3, 4 and the 4, 3 groups).   My groups have 6 pieces of data though, but thought that be easier to work with.  Anyone have anything out there?

Thanks,

Craig

[Keith Andersen]

How many rows/cells of data are you talking about? Is it all numbers? 

Keith 

Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/e6e6a045-8492-4f39-b06e-c4e376cc2c7en%40googlegroups.com.

[Craig Willett]

Hey Keith,

Here's an actual screenshot of the data.   It's a fantasy HR Derby thing I run.  I want to be able to check for duplicate rosters.  These rosters go from E1:N119.

[Keith Andersen]

Are you looking to find if one card of six players is exactly like another card of six players? Or are you trying to find out if something different?

Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/20b2231a-095a-488c-9845-c4075182c042n%40googlegroups.com.

[Craig Willett]

That's exactly what I'm trying to find.  If there are two teams with all 6 players the same.  They won't be in the same order necessarily, but just that they have the same exact roster.  

[Keith Andersen]

My suggestion....see this sheet

https://docs.google.com/spreadsheets/d/14OsSrY664E2W_s84gQWSBQkKH0SJhy-60r9oUolTHF8/edit?usp=sharing

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/8e720f4b-364b-4022-ab53-eaab8f9e0a8dn%40googlegroups.com.

--

sites.google.com/view/klaweb/

Passions: God, Family, Friends, Scripture, Data Management, Google Sheets + App Script, MS Access, Programing, sharing and much more.

[Laurie Nason]

Hi Craig,

I am guessing it doesn't matter which order they appear in, could you use a helper column (H) where you have the following function :

=textjoin("|",true,SORT(TRANSPOSE(A2:F2)))

--

[Laurie Nason]

I realise now that this is going across columns - but the same principle would apply for across rows (you wouldn't need the "TRANSPOSE" part - I would put in a hidden row at the top of each group to do the calculation.

[Craig Willett]

Hey Keith, I think this might work.  Not too hard to implement either.  I'll give this a shot.  Thanks

[Keith Andersen]

Welcome 👍😁

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/44045cc3-8740-42f7-9964-f0267dc814a0n%40googlegroups.com.