uqh65q
01-14-2012, 03:59 AM
In a boy’s club I have the following excel database.
I have added a priority field and would like to select from the highest priority for example Frost must attend the ‘Doctor’ which is priority 1, if his ‘Doctor’appointment is cancelled then priority 2 ‘Test’ would become the highest priority and if that were cancelled then priority 3 ‘Dentist’ would take its place and so on. However if the ‘Doctor’ subsequently became available then this would again become priority 1.
I hope this is understandable and that someone out there canhelp
I have added a priority field and would like to select from the highest priority for example Frost must attend the ‘Doctor’ which is priority 1, if his ‘Doctor’appointment is cancelled then priority 2 ‘Test’ would become the highest priority and if that were cancelled then priority 3 ‘Dentist’ would take its place and so on. However if the ‘Doctor’ subsequently became available then this would again become priority 1.
I hope this is understandable and that someone out there canhelp