Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Male/Female notation
I have created a log which requires a person to note whether the customer was
a male or female. Is there a way I can make any keystroke in the "Male" column = "Male" or any keystroke in the female column = "Female." IS thera better way to handle this entry? (ex. 1 column instead of 2) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Male/Female notation
Several ways. Data Validation where the user would have to select from a list or a worksheet_change event where if anything entered into the column desired Male would be filled in. Why not just use an x -- Don Guillett Microsoft MVP Excel SalesAid Software "toby" wrote in message ... I have created a log which requires a person to note whether the customer was a male or female. Is there a way I can make any keystroke in the "Male" column = "Male" or any keystroke in the female column = "Female." IS thera better way to handle this entry? (ex. 1 column instead of 2) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I auto transform sets of data? (change "female" to "f") | Excel Discussion (Misc queries) | |||
Cell Notation | Excel Discussion (Misc queries) | |||
howdo i make a chart showing grades for male and female students | New Users to Excel | |||
Scientific notation of CSV | Excel Discussion (Misc queries) | |||
How do you define labels (e.g. 1 = male) in excel? | Excel Discussion (Misc queries) |