| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list box item
Hello,
sheet1 in A column create l list name is item contain a2:a5000 look like below ball bat hocky ball bat carrom vollyball football hocky carrrom...... and B1 cell cotain validatiion list item now my problem is B1 cell show double item like bat 2 time carrom 2 time how |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
list box item
See John Walkenbach's site for code to limit listbox fillrange to
unique items only. http://spreadsheetpage.com/index.php..._unique_items/ Gord On Sun, 18 Mar 2012 13:23:54 -0500, kalpesh wrote: Hello, sheet1 in A column create l list name is item contain a2:a5000 look like below ball bat hocky ball bat carrom vollyball football hocky carrrom...... and B1 cell cotain validatiion list item now my problem is B1 cell show double item like bat 2 time carrom 2 time how |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
list box item
Gord Dibben formulated the question :
See John Walkenbach's site for code to limit listbox fillrange to unique items only. http://spreadsheetpage.com/index.php..._unique_items/ Gord On Sun, 18 Mar 2012 13:23:54 -0500, kalpesh wrote: Hello, sheet1 in A column create l list name is item contain a2:a5000 look like below ball bat hocky ball bat carrom vollyball football hocky carrrom...... and B1 cell cotain validatiion list item now my problem is B1 cell show double item like bat 2 time carrom 2 time how Might not be a solution since the oP refs the DV dropdown list! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
list box item
Should have clarified.
I posted John's solution as an alternative. To get uniques in a DV dropdown I think OP would have to first filter for uniques, copy to a new location then use that list. Gord On Sun, 18 Mar 2012 18:52:51 -0400, GS wrote: Might not be a solution since the oP refs the DV dropdown list! -- Garry |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
list box item
Gord Dibben has brought this to us :
Should have clarified. I posted John's solution as an alternative. To get uniques in a DV dropdown I think OP would have to first filter for uniques, copy to a new location then use that list. Gord On Sun, 18 Mar 2012 18:52:51 -0400, GS wrote: Might not be a solution since the oP refs the DV dropdown list! -- Garry I agree! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
| I need to pair each item on one list to each item on another list | Excel Worksheet Functions | |||
| Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
| Last list item selected in a Multi-Select list box? | Excel Programming | |||
| Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions | |||
Linear Mode
