Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple entries from a list
I use excel to keep track of a maintenance tasks i preform on equipment, i
use a drop down list that is set to a legand cell. i need to know if there is a way to make more than one entrie in that cell, for instance D9 is one of the drop downs, i would need to put C and A for cleaned and adjusted. right now i can only chose one but i would like to be able to put in more than one as about half of the items i check need to be cleaned as well as having some other task done to them that needs to be recorded. This is information that will be looked at by a the state inspectors as well as JCAHO so i need to be as clear as possable. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple entries from a list
Download a sample workbook from Debra Dalgleish's site.
http://www.contextures.on.ca/excelfiles.html#DV0017 Note that you can have the selections in an adjacent cell or in the same cell. As written it creates a comma delimited list or selected entries. Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 07:51:10 -0800, Godspeed wrote: I use excel to keep track of a maintenance tasks i preform on equipment, i use a drop down list that is set to a legand cell. i need to know if there is a way to make more than one entrie in that cell, for instance D9 is one of the drop downs, i would need to put C and A for cleaned and adjusted. right now i can only chose one but i would like to be able to put in more than one as about half of the items i check need to be cleaned as well as having some other task done to them that needs to be recorded. This is information that will be looked at by a the state inspectors as well as JCAHO so i need to be as clear as possable. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine Multiple Entries with differing amounts of entries | Excel Worksheet Functions | |||
how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
make a list from another list ignoring duplicate entries from orig | Excel Worksheet Functions | |||
multiple item entries from drop-down list | Excel Discussion (Misc queries) | |||
How do I Select Multiple entries from Valid list for a Cell | Excel Discussion (Misc queries) |