couples

Hello everybody. I'm in the situation you can see in the link: https://imgur.com/a/fRxpUnM In Cartel1 initially only column A is populated, then we have to refer to the sheet name in order to compose couples of data (1111Red, 1112Red, 1113Red, ...) comparable in Cartel2 to the combination of...

as suggested by Sandy666 I a man starting a new thread. I have a list of 160 golfers made up of 80 couples. These couples have different handicaps but to make it fair I am trying to make up 40 teams of 4 people keeping spouses together and trying to get the total handicap for each 4 some to be...

I have a file of 160 golfers. There are 80 couples with varying levels of handicaps from as low as 4 to a high of 17. I want to be able to make 40 teams keeping the spouses together so that the resulting total handicaps per 4some is around 50. Unfortunately there are some couples that each have...

I have a file with 40 plus couples with last names, first name in two consecutive rows of a column. I have another column that has a single value. The values for each couple ie two rows of a column is different. I want to sort the file keeping the couples together but sorted by the value of the...

I have 160 golfers. All the golfers have handicaps. 90% of the golfers are spouses. The handicaps for a 9 hole course vary from 3 to 18. I want to be able to keep the couples together and be able to automatically build 40 teams of 4somes so that the total handicap of each 4some is as close as...

I have 30 couples meeting each month for 7 months in groups of 3 couples(10 groups). How can they be arranged so they are always with different couples each month - no duplication?