yet another excel one for VoG

  keith-236785 19:25 07 Jan 05
Locked

Hi

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

keith

p.s he also wants to have the facility to change a venue manually before printing.

  ACOLYTE 19:32 07 Jan 05

There is a post about naming people in posts and although i cant help with your post i thought i would point this out.


click here

  VoG II 19:35 07 Jan 05

Yes, Excel can do this. If you set up the basic table then let us know how the data are arranged, this should be pretty straightforward.

I suggest that you set up a separate sheet that simply lists (unconnected) the players and possible venues. Simply as lists of possibilities.

  keith-236785 20:10 07 Jan 05

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.

thanks

Keith

  keith-236785 09:36 09 Jan 05

Just an update, i have contacted my nephew who says he will sort out some data, but knowing him it could be a while so thanks again and i will start a new post on this when i have the info.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…