John Corbin
05-15-2008, 09:04 AM
I am attaching a sample sheet as a reference.
in fact the sheet could contain hundreds if not thousands of rows.
Problem...
Look at column Player 1, the last 3 characters are AoS.
I want to find any rows where Player 1 has those three characters ( AoS ) and swap them with the contents of the Player 2.
BUT if that swap happens then the following swaps must occur as well:
Contents of Column "Side 1" swaps with Contents of Colum "Side 2"
Contents of Column "Player 1 Pts" swaps with Contents of Column "Player 2 Pts"
Ultimately I want this extended so that is the letters AoS appear in any of the following columns ( Player 4, Player 6, Player 8, Player 10)
the following swaps happens:
Contents of Column "Player 3" swaps with Contents of Column "Player 4"
Contents of Column "Side 3" swaps with Contents of Column "Side 4"
Contents of Column "Player 3 Pts" swaps with Contents of Column "Player 4 Pts"
Contents of Column "Player 5" swaps with Contents of Column "Player 6"
Contents of Column "Side 5" swaps with Contents of Column "Side 6"
Contents of Column "Player 5 Pts" swaps with Contents of Column "Player 6 Pts"
Contents of Column "Player 7" swaps with Contents of Column "Player 8"
Contents of Column "Side 7" swaps with Contents of Column "Side 8"
Contents of Column "Player 7 Pts" swaps with Contents of Column "Player 8 Pts"
Contents of Column "Player 9" swaps with Contents of Column "Player 10"
Contents of Column "Side 9" swaps with Contents of Column "Side 10"
Contents of Column "Player 9 Pts" swaps with Contents of Column "Player 10 Pts"
Appreciate any help
John
in fact the sheet could contain hundreds if not thousands of rows.
Problem...
Look at column Player 1, the last 3 characters are AoS.
I want to find any rows where Player 1 has those three characters ( AoS ) and swap them with the contents of the Player 2.
BUT if that swap happens then the following swaps must occur as well:
Contents of Column "Side 1" swaps with Contents of Colum "Side 2"
Contents of Column "Player 1 Pts" swaps with Contents of Column "Player 2 Pts"
Ultimately I want this extended so that is the letters AoS appear in any of the following columns ( Player 4, Player 6, Player 8, Player 10)
the following swaps happens:
Contents of Column "Player 3" swaps with Contents of Column "Player 4"
Contents of Column "Side 3" swaps with Contents of Column "Side 4"
Contents of Column "Player 3 Pts" swaps with Contents of Column "Player 4 Pts"
Contents of Column "Player 5" swaps with Contents of Column "Player 6"
Contents of Column "Side 5" swaps with Contents of Column "Side 6"
Contents of Column "Player 5 Pts" swaps with Contents of Column "Player 6 Pts"
Contents of Column "Player 7" swaps with Contents of Column "Player 8"
Contents of Column "Side 7" swaps with Contents of Column "Side 8"
Contents of Column "Player 7 Pts" swaps with Contents of Column "Player 8 Pts"
Contents of Column "Player 9" swaps with Contents of Column "Player 10"
Contents of Column "Side 9" swaps with Contents of Column "Side 10"
Contents of Column "Player 9 Pts" swaps with Contents of Column "Player 10 Pts"
Appreciate any help
John