Home |
Search |
Today's Posts |
#1
|
|||
|
|||
populate data valadation list by criteria
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 |
#2
|
|||
|
|||
populate data valadation list by criteria
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 John in Surrey wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create template that ignors data list rules | New Users to Excel | |||
Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) | |||
Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) | |||
drop-down list in data valadation does not work | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |