Nov 06 2020 01:51 PM
I am having trouble with a good way to filter out a repeat set of names in a list.
For example: I have ten Projects, I have randomly selected team members to work on each project, however I don't want the same combination of team members to work on any given project. (In my example below Project 1 and 8 are the same team members) can someone help me with a good way to flag the repeat combination?
Nov 07 2020 07:57 AM
The truth is, it would be a lot easier to help you with a precise example if you posted the spreadsheet you used to create that image. Otherwise you're asking anybody here to spend time re-creating it.
That said, here are the steps I'd go through if I had the spreadsheet. These steps do presume you have the most recent version of Excel, which contains what are called Dynamic Array functions like SORT, UNIQUE, FILTER. I'm also presuming that each team always has the same number of members. If sometimes there are teams of 8, sometimes 5, etc., it gets trickier, but still can be solved. Write back if that's the case.
If you do have that most recent version of Excel