populate data valadation list by criteria

[John in Surrey]

hi
I wish to use data valadation to choose a staff member, but I only
want to poplate the list with staff with grades from C to G...

Sun 06/11
Name grade M/F am pm
Anne C F
Carol G F
David E F
Mary A M
Anne A M
Sharon A F
Henery A M

total qualified =DCOUNTA(B84:E109,Sun_am,D3:E5) works well, I
get a total of qualifed staff on the shift
Ward Round (data valadation to list / choose a staff with
grades c to g)
only staff with these grades can do the ward round

I have used Dcounta to count staff with grades c to g that I have
rostered on for the shift, now I wish to populate a list using the
same logic.

thanks
john
john
Images of home (NZ)
http:\\www.myplace.co.nz/home
What we are up to in the UK
http:\\www.myplace.co.nz

 

[Roger Govier]

Hi John

Copy a filtered list of staff who meet your criteria to column A of a new
sheet, name the range as Available and make this range the list in your data
validation.

for more information on DV take a look at Debra Dalgleish's site.
http://www.contextures.com/xlDataVal01.html

Regards

Roger Govier