FreakyGirl
Member
hello again
your code worked perfectly. i was able to complete the first section of my worksheet for single player games. i cant thank you enough.
however, when trying to apply your code for the second part of my worksheet im finding its not giving me the correct values. (G-H) once a name has been used i cant continue & have it be correct.
starting fresh & using the same values from before K-R
when pards is played i need to combine the first 2 names together with scores & the last 2 names together & scores.
K2 & M2 (names) & L2 & N2 (scores). O2 & Q2 (names) & P2 & R2 (scores) this will always be the format & they will be listed under their colors in order blue, green, red, yellow.
when i take the list of unique names & use offset to give me the pairings it doesnt show all of them because some names may have had diff pards. G28 shows renee as not having a pard when in fact she was with angel as shown in O24/Q24. since the pards share points she will not have the right amount.
so i thought well why not put the names together to create a unique string. but before i could pat myself on the back i seen yet another problem. ie: AO7 & AO28 are the same players but they switched colors when they played their 2nd game.
sigh... back to the drawing board.
each row represents 1 game played & will create a unique string for a starting point.
but on the 2nd game played they can sit any which way.
chihiro/bosco sat blue/green respectivly game 1. you didnt do to well so you decided to switch it up for game 2 & you decide to sit as chihiro in yellow & bosco in red. i added your names in to reflect that. (code worksheet CN-CU) & you now show up in CO35/CO36
for less scrolling, column AP-AS now represent the pards & their scores.
AT-AU shows the number of times that each team has played in that column. the desired number is 2 or more.
if less than 2 in AT then i need to check for reversals of the names or original names in the other columns (AP-AS)
name will show up so i can do an an index/match in AX to see if they are in the other column of names (AR) if AU is less than 2 i switch the order of names to see the other column.
after seeing the results im not sure this is the way to go either. perhaps i should have stuck with the original way (AM-AN) with the names put together to create the unique string & used SEARCH to look for a name within a name.
ie: bosco will be located in chihirobosco or boscochihiro. but how to apply that logic to get the desired results.
IF(AT2>=2,SEARCH(M2,AM2,1),"")) which will tell me the start postion of the 2nd name. if 1 is the value returned than i know the names have been switched.
if you could pls guide me into which way i should be doing this it would be most helpful. anything past AL can be deleted. those are just helper columns.
its very frustrating to know what you want to do but not the proper way or function to use.
thanks for your time,
FreakyGirl