Forum Discussion

Vicphuket's avatar
Vicphuket
Copper Contributor
Oct 18, 2020

Excel spreadsheet managing

I have a small table 5 columns x 12 rows. For convenience use the spreadsheet cell identifiers, A1 to E12. E5 to E12 contain a formulae that relates to the information in columns A1,B1 & D1. I want ...
itrainem's avatar
itrainem
Copper Contributor
Oct 19, 2020

Vicphuket It would be helpful to see an image with your question in order to more fully understand the sort you trying to complete.  Without more detail, the question would be, "why not just sort all the columns and rows?"

itrainem 

  • Vicphuket's avatar
    Vicphuket
    Copper Contributor
    Oct 20, 2020

    This is the scenario
    12 guys going on a golf trip playing 4 rounds of golf at 4 different courses
    They will play in groups of 4 (4 balls) each day.
    The task is to sort the 4 balls in such a way as nobody plays with the same person more than twice over the 4 rounds.
    Each player has his official U.S.G.A. Index for his home course which will not change during the trip, Column C.
    Column A shows the heading for the groups (4 balls) and the day.
    Column B is the Letter allocated to the player. The order of the letters change for each course and the data relating to the player must relocate to the new position each day. Note that the cells in the handicap column contain Absolute references ie Slope, Rating & Par.
    Column D is the players name under the course to be played.
    Column E is the players handicap based on the Slope, Course Rating & Par (different for each course) The cells in this column contain a formula that calculates the players handicap.
    They will play a different course each day
    They will use the USGA world index system to determine there handicap at each course.

    i hope the grids attached are self explanatory, but I have tediously carried out the sorting manually

    vic

     

Resources