| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation list sort order
I have a problem with my data validation list it starts at the bottom often
blank instead of at the top of the list, please advise how to correct this. Greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation list sort order
http://www.contextures.com/xlNames01.html#Dynamic
or don't include blank cells in your list range -- Regards, Peo Sjoblom "PCreighton" wrote in message ... I have a problem with my data validation list it starts at the bottom often blank instead of at the top of the list, please advise how to correct this. Greatly appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation list sort order
yes i use this for some others have formaula so the cell is not seen as
empty, that said even using dynamic it does not always start at top of list usully at bottom how do I get it to start at top of the list when click on arrow? "Peo Sjoblom" wrote: http://www.contextures.com/xlNames01.html#Dynamic or don't include blank cells in your list range -- Regards, Peo Sjoblom "PCreighton" wrote in message ... I have a problem with my data validation list it starts at the bottom often blank instead of at the top of the list, please advise how to correct this. Greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation list order | Excel Worksheet Functions | |||
| VALIDATION LIST ORDER | Excel Worksheet Functions | |||
| Can I sort a list to match a previously existing order? | Excel Worksheet Functions | |||
| How to sort al list in random order for sampling? | Excel Discussion (Misc queries) | |||
| How do you sort a list of dates into date order | Excel Discussion (Misc queries) | |||
Linear Mode
