Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF THEN in cell?
I am taking over a spreadsheet that has a list of options that is specific to
one name in it. Currently when you choose this guy's name, the user has to hunt and peck for the choices that are specific to him. Is there a way that I can force Excel to display just those choices when his name is chosen? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF THEN in cell?
Heather Lou,
Visit he http://www.contextures.com/xlDataVal02.html for a technique to do what you want. HTH, Bernie MS Excel MVP "HeatherLou1974" wrote in message ... I am taking over a spreadsheet that has a list of options that is specific to one name in it. Currently when you choose this guy's name, the user has to hunt and peck for the choices that are specific to him. Is there a way that I can force Excel to display just those choices when his name is chosen? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |