Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I want to be able to select "sort ascending" or "sort descending" from the
drop down menu on a list of dates that apply to a name e.g. list A list B gary 26/06/06 helen 23/06/06 greg 01/07/07 and have the names linked to the dates rather than just sort the dates as an individual column. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Select the whole table (2 columns) before you sort on column B
HTH -- AP "adaire" a écrit dans le message de news: ... I want to be able to select "sort ascending" or "sort descending" from the drop down menu on a list of dates that apply to a name e.g. list A list B gary 26/06/06 helen 23/06/06 greg 01/07/07 and have the names linked to the dates rather than just sort the dates as an individual column. |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
On Mon, 03 Jul 2006 09:23:19 +0100, Ardus Petus
wrote: Select the whole table (2 columns) before you sort on column B HTH -- AP "adaire" a écrit dans le message de news: ... I want to be able to select "sort ascending" or "sort descending" from the drop down menu on a list of dates that apply to a name e.g. list A list B gary 26/06/06 helen 23/06/06 greg 01/07/07 and have the names linked to the dates rather than just sort the dates as an individual column. Quick - tip If you click on a single cell in the table, it will use the *table* containing that cell (Need complete data in table, no blank lines, columns etc) -- Steve (3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting a sheet with outlined rows | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Inserting rows, updating linked worksheet | Excel Worksheet Functions | |||
Sorting Rows by Color | Excel Discussion (Misc queries) | |||
sorting detail rows - summary row in an outline | Excel Discussion (Misc queries) |