Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
if certain cells equal a name then i do not want other cells to have the same
name. For example: Cell B1 has NFL team names in a drop down menu, in cell C1 i do not want the same team to be selected as it was in B1. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Have a look at Debra Dalgleish's site he
http://www.contextures.com/xlDataVal03.html This covers hiding previously-selected items and should cover what you want to do. Hope this helps. Pete On Jul 5, 6:10 pm, cele25 wrote: if certain cells equal a name then i do not want other cells to have the same name. For example: Cell B1 has NFL team names in a drop down menu, in cell C1 i do not want the same team to be selected as it was in B1. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Thu, 5 Jul 2007 10:10:01 -0700 from cele25 <cele25
@discussions.microsoft.com: if certain cells equal a name then i do not want other cells to have the same name. For example: Cell B1 has NFL team names in a drop down menu, in cell C1 i do not want the same team to be selected as it was in B1. Data Validation. (You might want to get your keyboard fixed, too: the Shift key seems to work only intermittently.) -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|