| 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 |
| 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 | |||
Threaded Mode
