| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to select the date?
Does anyone have any suggestions on how select the date?
There is a list of date under column A, and numbers under column B 02-Jan-08 1 06-Jan-08 2 06-Jan-08 0 12-Jan-08 1 16-Jan-08 1 20-Jan-08 3 21-Jan-08 4 23-Jan-08 4 24-Jan-08 3 30-Jan-08 2 01-Feb-08 3 03-Feb-08 3 06-Feb-08 3 07-Feb-08 2 I would like to select the date with higher numbers, the higher number and smaller number in date always select firstly It should show the result under D column, as show below 21-Jan-08 23-Jan-08 20-Jan-08 24-Jan-08 30-Jan-08 01-Feb-08 03-Feb-08 06-Feb-08 07-Feb-08 02-Jan-08 12-Jan-08 16-Jan-08 06-Jan-08 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select date in date range | Excel Worksheet Functions | |||
| Date Select Macro | Excel Discussion (Misc queries) | |||
| Select the most recent date | Excel Worksheet Functions | |||
| Select criteria based on date | Excel Discussion (Misc queries) | |||
| date criteria to select range | Excel Worksheet Functions | |||
Threaded Mode
