(NOT if one says this give me another set of options)
Hi
I working on a spreadsheet for my BTEC IT , my task is To create a spreadsheet to manage a football clubs 'Season ticket Information'. one of my requirements is have a system to automatically assign people if they have no choice on seating area to the area with most space.
I have two columns Requested and allocated seat ( L and M ) Both with data validation of my seating areas (Found Below). I have already made the a table to workout the area with the most free space found on my FX sheet which automatically updates. I would like to able to select "Not Specified" in column L (Requested) and in column M (Allocated) it two input the area which the most free space found from my ranked table and overwrite any thing that has already been selected in column M
Is this possible and if so how would i do this as cant find anything online and my teacher is useless, would be much appreciated :p
Seating Areas:
- North Upper
- North Lower
- East Upper
- East Lower
- South Upper
- South Lower
- West Upper
- West Lower
- Home Goal
- Away Goal
Thanks
Mathew Speed
My spreadsheet if you want to have a look i have attached it as a zip. Mathew Speed IT CA.zip
Bookmarks