Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
enter data in a cell from a list you specify with auto complete function
|
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"Pick from list" only provides a list of unique contiguous items in a column.
Autocomplete also works only with contiguous data in a column. Gord Dibben MS Excel MVP On Tue, 18 Mar 2008 00:14:00 -0700, Morris wrote: enter data in a cell from a list you specify with auto complete function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
autocomplete in dropdown list in Excel as I begin typing | Excel Worksheet Functions | |||
How do I pick value A from a list and have excel return value B? | Excel Worksheet Functions | |||
Excel 2002 : Formula to pick up codes | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
How do I pick a number from a list in Excel? | Excel Worksheet Functions |