| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sort the data in drop down list
I need help to solve 2 problems. Any one could help me pls.
column A column B 1 province 3 John 2 province 2 Barbara 3 province 3 Sam 4 province 3 Lilly above is my data. 1)I want to have drop down list in cell("c1") to show a1:a4 (sort a-z) like this province2 province3 2)if in the cell("c1") is province2 the cell("d1") could show drop down list only "Barbara" thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to sort the data in drop down list
Not quite what you asked, but you could rearrange your data, add some workbook
names and then use a technique from Debra Dalgleish's site: http://contextures.com/xlDataVal02.html Sumeth wrote: I need help to solve 2 problems. Any one could help me pls. column A column B 1 province 3 John 2 province 2 Barbara 3 province 3 Sam 4 province 3 Lilly above is my data. 1)I want to have drop down list in cell("c1") to show a1:a4 (sort a-z) like this province2 province3 2)if in the cell("c1") is province2 the cell("d1") could show drop down list only "Barbara" thanks, -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to sort the data in drop down list
Thanks Dave.
I can do it right now. "Dave Peterson" wrote: Not quite what you asked, but you could rearrange your data, add some workbook names and then use a technique from Debra Dalgleish's site: http://contextures.com/xlDataVal02.html Sumeth wrote: I need help to solve 2 problems. Any one could help me pls. column A column B 1 province 3 John 2 province 2 Barbara 3 province 3 Sam 4 province 3 Lilly above is my data. 1)I want to have drop down list in cell("c1") to show a1:a4 (sort a-z) like this province2 province3 2)if in the cell("c1") is province2 the cell("d1") could show drop down list only "Barbara" thanks, -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i set up a drop down list and hide my list data. | Excel Worksheet Functions | |||
| ? sort data in a drop down box w/ initial cell entry | Excel Worksheet Functions | |||
| How to sort a drop-down list? | Excel Worksheet Functions | |||
| How do I manipulate/sort data from a drop-down Excel list? | Excel Discussion (Misc queries) | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
Hybrid Mode
