Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting list to a new place`
windows XP, microsoft office 2003, Excel
when sorting a list (ie names) to a new place, <unique values marked, the initial name re-appears within the list, so we have 2 instances of the same data. How can I eliminate this bug ?? -- Basilio |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting list to a new place`
I hate tis problem. I found adding a unique header row eliminates this
problem. "basilio" wrote: windows XP, microsoft office 2003, Excel when sorting a list (ie names) to a new place, <unique values marked, the initial name re-appears within the list, so we have 2 instances of the same data. How can I eliminate this bug ?? -- Basilio |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting list to a new place`
thanks Joel
I have tried this myself after noting that it is only the first name to re-apper in the new list of unique names. the fact is I want to use that <sorted list as a pull down menu and I don't want the header to re-apper. Thanks anyway -- Basilio "Joel" wrote: I hate tis problem. I found adding a unique header row eliminates this problem. "basilio" wrote: windows XP, microsoft office 2003, Excel when sorting a list (ie names) to a new place, <unique values marked, the initial name re-appears within the list, so we have 2 instances of the same data. How can I eliminate this bug ?? -- Basilio |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting list to a new place`
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting table of numbers with different place values | Excel Worksheet Functions | |||
Place a list box in a cell | Excel Programming | |||
Place a list box in a cell | Excel Programming | |||
extract data from a random list & place in another ordered list | Excel Discussion (Misc queries) | |||
How can I place a condition on a list? | Excel Discussion (Misc queries) |