My nephew has asked me if it is possible to use excel formulas to pick the players and venues for a local pool league, its a little more complex than i can handle though.
he will need a list of players in column B, thier home venue in column C, and the list of available venues in column D
what he needs is for the formula to pick two players at random (column B), check thier venues (column C) and then pick a venue (column D) for the game so that niether is at thier home venue (C), these players and the venue then need removing from the pick list.... to repeat until all the players have been selected he will then need to print out the result.
i just need to know if excel can do this before i start trying to set up the spreadsheet and enter all the names.
thanks in advance
p.s he also wants to have the facility to change a venue manually before printing.
ACOLYTE, sorry i hadn't seen the thread regarding naming people (i have now though), but we all know the real excel experts include VoG among others but my heading wasnt YO VoG,,,, it was slightly more descriptive but i accept the slap on the hand.
VoG, thanks for the info i will contact my nephew and ask him to be more specific and also see if he has any spreadsheets already set up.